Re: Foreign Key Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: operationsengineer1(at)yahoo(dot)com
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Foreign Key Problem
Date: 2005-05-03 02:18:55
Message-ID: 4678.1115086735@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<operationsengineer1(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-05-03 02:24:28 Re: Foreign Key Problem
Previous Message Ennio-Sr 2005-05-02 22:25:15 psql not warning while creating a wrong function?