<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