From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Foreign Key Problem |
Date: | 2005-05-03 02:24:28 |
Message-ID: | 20050503022428.98136.qmail@web52402.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--- 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
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2005-05-03 02:30:09 | Re: CONSTRAINT ... FOREIGN KEY |
Previous Message | Tom Lane | 2005-05-03 02:18:55 | Re: Foreign Key Problem |