From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Colin Beckingham <colbec(at)start(dot)ca> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: dev 1.15 wxwidgets - constraints with multiple tables |
Date: | 2012-04-06 18:40:55 |
Message-ID: | 1333737655.20329.3.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, 2012-04-06 at 08:03 -0400, Colin Beckingham wrote:
> Given 3 tables, authors, books and words, each has a primary key.
>
> Attempting to use pgadmin to add a foreign key to books to link authors
> to books, and a key to words to link words to books.
>
> The first step works ok (ignoring previously reported backtrace) and the
> foreign key is added to books linking it to authors. However when
> attempting to add a foreign key to words, pgadmin can still only see the
> authors table as a reference table.
>
> Tried reloading and refreshing but pgadmin does not seem to see beyond
> the authors table for the 'referencing' dropdown.
>
> Maybe I am missing a step. table books definitely has a primary key.
Can you give us your tables' definition? Thanks.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Beckingham | 2012-04-06 19:11:29 | Re: dev 1.15 wxwidgets - constraints with multiple tables |
Previous Message | Guillaume Lelarge | 2012-04-06 18:40:06 | Re: dev 1.15 wxwidgets 2.9.3 - adding constraints |