I discovered a subtle bug within the dialog for foreign key creation:<br /><br />Be there a database "testdb"
structuredlike:<br clear="all" /><br />CREATE SCHEMA nb1;<br /><br />CREATE TABLE nb1.hauptbaer (<br /> id_baer
serialNOT NULL, <br /> fischfeld text<br />);<br /><br />ALTER TABLE nb1.hauptbaer<br /> ADD CONSTRAINT
hauptbaer_pkeyPRIMARY KEY(id_baer);<br /><br />CREATE TABLE nb1.nebenbaer (<br /> id_nb serial NOT NULL,<br />
redetext,<br /> id_baer integer <br />);<br /><br />ALTER TABLE ONLY nb1.nebenbaer<br /> ADD CONSTRAINT
nebenbaer_pkeyPRIMARY KEY (id_nb);<br /><br />that is, within schema "nb1" there are two tables "nb1.hauptbaer" and
"nb1nebenbaer". <br /><br />The database, the schema, everthing is owned by a user named nb1.<br /><br />Now create a
connectionto the database testdb as user nb1.<br /><br />When going to "nebenbaer" and trying to add a foreign key
constraintto id_baer of hauptbaer... <br /><br />you can select hauptbaer from the list of tables, but there is no
schemeprefix. On the dialog-tab where you need to select the columns for the fkey relationship, no column from
hauptbaeris shown.<br /><br />My guess it's that the nb1-scheme is dropped out because it's same as username. <br /><br
/>IfI connect as postgres or any other user, creating that restriction works fine. I can select columns and all.<br
/><br/>I hope I explained understandable; if I can do anything more to make it reproducable, please let me know. <br
/><br/>Harald<br /><br /><br /><br /><br />-- <br />GHUM Harald Massa<br />persuadere et programmare<br />Harald Armin
Massa<br/>Reinsburgstraße 202b<br />70197 Stuttgart<br />0173/9409607
