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