Thread: ForeignKey dialog does not show columns of tables in same shema

ForeignKey dialog does not show columns of tables in same shema

From
"Harald Armin Massa"
Date:
Version 1.4.2 on Windows XP, freshly installed from the "official" .msi<br /><br /><br />situation:<br /><br />database
schemaibox containts table <br /><br />filestore <br />- id_fs inet<br />- content bytea<br />- morecol text<br /><br
/>andfs2objekt<br />- id_fs inet<br />- whatever text<br /><br />I try to create a foreign key on f2objekt, referencing
filestore<br/><br />The dialogue does show all the tables within schema ibox, but if I select on "dialog tab 1"
filestoreas referred table, I cannot select ANY column of filestore on the second tab. <br />On selecting one of the
fullyqualified public tables (i.e. public.pg_ts_parser) on tab1, I can select columns of that table in tab2<br /><br
/>Harald<br/><br clear="all" />-- <br />GHUM Harald Massa<br />persuadere et programmare <br />Harald Armin Massa<br
/>Reinsburgstraße202b<br />70197 Stuttgart<br />0173/9409607<br />-<br />PostgreSQL - supported by a community that
doesnot put you on hold