Thread: Bug report.

HI Dave,

Well this is just a pgAdmin GUI error while defining the foreign key
relationship.

Here is the steps to reproduce it.

1. After defining the columns in the given table.
2. Go to the 'Foreign Keys' tab (There it will pop up a menu).
3. Now in this menu, in the 'Properties' along with the other properties,
there is 'Referenced Table' pull down menu.
   Here you will select the table where you want to refer to.
4. After selecting this table, I go to the 'Relationships' tab.
5. Here, there are two lists, 'Local Column' and 'Referenced Column'.

Now the problem is...

When I select the 'Referenced Table', first time, the 'Referenced Column'
contains all the columns from the selected table. This is a valid behavior.
Now if I go back to the 'Properties' and select another table (say you chose
a wrong table earlier), and come back to the 'Relationships', the
'Referenced Column' contains all the columns from the last tables (which is
wrong selection) and the new selection.

I think this is not correct. Whenever you select the new 'Referenced Table'
name, the 'Referenced Column' list should also get refreshed accordingly so
that it will show columns of 'Referenced Table' only.

As its not a severe bug, does not affect the functionality.

-regds,
anil.

Anil,

Please use the pgadmin-support@postgresql.org mailing list for pgAdmin
issues rather than the Cygwin list. Also, I would appreciate it if you _not_
CC me on all your messages - it may not be me that responds to you.

Bug noted, thanks for the report.

Regards, Dave.

> -----Original Message-----
> From: Anil Jangam [mailto:anilj@indts.com]
> Sent: 19 December 2001 06:56
> To: 'Dave Page'
> Cc: pgsql-cygwin@postgresql.org
> Subject: [CYGWIN] Bug report.
> Importance: High
>
>
> HI Dave,
>
> Well this is just a pgAdmin GUI error while defining the
> foreign key relationship.
>
> Here is the steps to reproduce it.
>
> 1. After defining the columns in the given table.
> 2. Go to the 'Foreign Keys' tab (There it will pop up a
> menu). 3. Now in this menu, in the 'Properties' along with
> the other properties, there is 'Referenced Table' pull down menu.
>    Here you will select the table where you want to refer to.
> 4. After selecting this table, I go to the 'Relationships'
> tab. 5. Here, there are two lists, 'Local Column' and
> 'Referenced Column'.
>
> Now the problem is...
>
> When I select the 'Referenced Table', first time, the
> 'Referenced Column' contains all the columns from the
> selected table. This is a valid behavior. Now if I go back to
> the 'Properties' and select another table (say you chose a
> wrong table earlier), and come back to the 'Relationships',
> the 'Referenced Column' contains all the columns from the
> last tables (which is wrong selection) and the new selection.
>
> I think this is not correct. Whenever you select the new
> 'Referenced Table' name, the 'Referenced Column' list should
> also get refreshed accordingly so that it will show columns
> of 'Referenced Table' only.
>
> As its not a severe bug, does not affect the functionality.
>
> -regds,
> anil.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
http://www.postgresql.org/users-lounge/docs/faq.html