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. -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support