Re: Foreign Key Problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: Foreign Key Problem
Date
Msg-id 4678.1115086735@sss.pgh.pa.us
Whole thread Raw
In response to Foreign Key Problem  (<operationsengineer1@yahoo.com>)
List pgsql-novice
<operationsengineer1@yahoo.com> writes:
> when i go to the pgadmin 3 constraints folder, open
> this foreign key and click on the columns tab, it
> shows conflicting information.

> Local says "product_number"
> Referenced says "product_number"

> so far, so good.

> Referencing says ".......pg dropped 1......." in the
> drop down menu.  i previously had to drop my first
> created column.

Hmm, this is definitely a bug in pgadmin: it should be ignoring dropped
columns.   Perhaps you have an old version of pgadmin?  If it's current,
you should report the problem to the pgadmin list.

            regards, tom lane

pgsql-novice by date:

Previous
From: Ennio-Sr
Date:
Subject: psql not warning while creating a wrong function?
Next
From:
Date:
Subject: Re: Foreign Key Problem