Re: Foreign Key Problem - Mailing list pgsql-novice

From
Subject Re: Foreign Key Problem
Date
Msg-id 20050503044313.47986.qmail@web52407.mail.yahoo.com
Whole thread Raw
In response to Foreign Key Problem  (<operationsengineer1@yahoo.com>)
List pgsql-novice
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> <operationsengineer1@yahoo.com> writes:
> > tom, i don't know if this is a pgadmin display
> issue
> > or if it a pgsql issue.
>
> The presence of a dropped column in that dropdown
> menu is certainly
> a pgadmin bug.  I suspect that the bug may be
> leading to other
> misbehaviors, say for instance the display of which
> columns reference
> which might be offset by 1 because of the bogus
> appearance of the
> dropped column in the list.  But that is strictly a
> guess.
>
> You should get some pgadmin hackers involved before
> doing anything else.
> In particular, I'd counsel against dropping the
> tables involved before
> a fix has been verified, because it could be that
> there are more
> contributing factors than just "you dropped a
> column".  If you wipe the
> tables now you might be destroying evidence that is
> needed to fix the
> bug.  (And if the bug is indeed on the backend side
> rather than in
> pgadmin, that advice goes double.)
>
>             regards, tom lane
>

tom, thanks for the heads up.  i will make a copy of
the db and then work on the copy.

__________________________________________________
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: tövis
Date:
Subject: Re: CONSTRAINT ... FOREIGN KEY