Re: Legacy foreign keys - Mailing list pgsql-admin

From Tom Lane
Subject Re: Legacy foreign keys
Date
Msg-id 27759.1197345546@sss.pgh.pa.us
Whole thread Raw
In response to Legacy foreign keys  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-admin
"Peter Koczan" <pjkoczan@gmail.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

pgsql-admin by date:

Previous
From: "=?ISO-8859-1?Q?Elvis_Henr=EDquez?="
Date:
Subject: Re: Case studies
Next
From: Listaccount
Date:
Subject: Re: Dangerous hint in the PostgreSQL manual