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