Re: Foreign Key Problem

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

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