Re: Legacy foreign keys - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Legacy foreign keys
Date
Msg-id 20071210195046.GE27126@alvh.no-ip.org
Whole thread Raw
In response to Legacy foreign keys  ("Peter Koczan" <pjkoczan@gmail.com>)
Responses Re: Legacy foreign keys  ("Peter Koczan" <pjkoczan@gmail.com>)
Re: Legacy foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Peter Koczan escribió:
> Hi all,
>
> 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

8.3's pg_dump contains smarts to dump these things as normal FKs.  Try
it.

--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"Postgres is bloatware by design: it was built to house
 PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)

pgsql-admin by date:

Previous
From: lattab kader
Date:
Subject: Postgres installation problem
Next
From: "Peter Koczan"
Date:
Subject: Re: Legacy foreign keys