| From: | "Peter Koczan" <pjkoczan(at)gmail(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Legacy foreign keys |
| Date: | 2007-12-10 19:53:12 |
| Message-ID: | 4544e0330712101153u124b6e41x77f9b9b86151c470@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Dec 10, 2007 1:50 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> 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.
Oh, that explains the problems...I was using 8.2's pg_dump. I'll try
it out. Thanks.
Peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-12-10 20:47:50 | Re: Dangerous hint in the PostgreSQL manual |
| Previous Message | Alvaro Herrera | 2007-12-10 19:50:46 | Re: Legacy foreign keys |