bug with fkey-dialog in tables belonging to schemes - Mailing list pgadmin-support

From Harald Armin Massa
Subject bug with fkey-dialog in tables belonging to schemes
Date
Msg-id 7be3f35d0512090716u338123caq@mail.gmail.com
Whole thread Raw
Responses Re: bug with fkey-dialog in tables belonging to
Re: bug with fkey-dialog in tables belonging to
Re: bug with fkey-dialog in tables belonging to
List pgadmin-support
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  

pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pgagent problems
Next
From: Andreas Pflug
Date:
Subject: Re: pgadmin 1.4 not remembering password