Re: Legacy foreign keys

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Legacy foreign keys
Date: 2007-12-11 03:59:06
Message-ID: 27759.1197345546@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Peter Koczan" <pjkoczan(at)gmail(dot)com> writes:
> I am having a problem with what appear to be legacy foreign keys in
> some of my databases (probably pre-7.2 days). They won't restore from
> 8.2 to 8.3, because the '<unnamed>' field in the called function isn't
> unique when I try to restore more than one of these legacy keys

BTW, I spent some time trying to reproduce that, without success;
so I'm now even more interested in seeing your example case.
I think your "because" diagnosis is probably wrong ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Listaccount 2007-12-11 08:23:38 Re: Dangerous hint in the PostgreSQL manual
Previous Message Elvis Henríquez 2007-12-11 03:49:38 Re: Case studies