bug with fkey-dialog in tables belonging to schemes
От | Harald Armin Massa |
---|---|
Тема | bug with fkey-dialog in tables belonging to schemes |
Дата | |
Msg-id | 7be3f35d0512090716u338123caq@mail.gmail.com обсуждение исходный текст |
Ответы |
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 |
Список | 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 по дате отправления: