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