Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3A8192E17F6 for ; Mon, 10 Dec 2007 23:59:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 88089-07 for ; Mon, 10 Dec 2007 23:59:08 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 89DD02E00A5 for ; Mon, 10 Dec 2007 23:59:08 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBB3x7A5027760; Mon, 10 Dec 2007 22:59:07 -0500 (EST) To: "Peter Koczan" cc: pgsql-admin@postgresql.org Subject: Re: Legacy foreign keys In-reply-to: <4544e0330712101112r6aeccfcckef378a7ea1795e07@mail.gmail.com> References: <4544e0330712101112r6aeccfcckef378a7ea1795e07@mail.gmail.com> Comments: In-reply-to "Peter Koczan" message dated "Mon, 10 Dec 2007 13:12:34 -0600" Date: Mon, 10 Dec 2007 22:59:06 -0500 Message-ID: <27759.1197345546@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/45 X-Sequence-Number: 27562 "Peter Koczan" 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 '' 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