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
