Re: Foreign Key Problem - Mailing list pgsql-novice

From
Subject Re: Foreign Key Problem
Date
Msg-id 20050503022428.98136.qmail@web52402.mail.yahoo.com
Whole thread Raw
In response to Foreign Key Problem  (<operationsengineer1@yahoo.com>)
Responses Re: Foreign Key Problem
List pgsql-novice
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> <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
>

tom, i don't know if this is a pgadmin display issue
or if it a pgsql issue.

if i don't get some guidance, i will likely delete
both the tables entirely and rebuild them from
scratch.

the behavior of trying to verify foreign key matches
in the wrong table - either b/c pgsql is screwing up
or, much more likely, i'm screwing up.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Foreign Key Problem
Next
From:
Date:
Subject: Re: CONSTRAINT ... FOREIGN KEY