Re: Foreign Key Problem

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> <operationsengineer1(at)yahoo(dot)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