Re: Legacy foreign keys

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Peter Koczan <pjkoczan(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Legacy foreign keys
Date: 2007-12-10 19:50:46
Message-ID: 20071210195046.GE27126@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Koczan 2007-12-10 19:53:12 Re: Legacy foreign keys
Previous Message Peter Koczan 2007-12-10 19:12:34 Legacy foreign keys