Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9D83E2E0059 for ; Thu, 1 May 2008 17:34:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09742-01 for ; Thu, 1 May 2008 17:34:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 49C752E003A for ; Thu, 1 May 2008 17:34:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m41KY8oB025102; Thu, 1 May 2008 16:34:08 -0400 (EDT) To: Geoffrey cc: Shane Ambler , pgsql-admin@postgresql.org Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1 In-reply-to: <481A20B9.3000403@serioustechnology.com> References: <4819EDF9.2080000@serioustechnology.com> <481A09B8.2070604@Sheeky.Biz> <481A20B9.3000403@serioustechnology.com> Comments: In-reply-to Geoffrey message dated "Thu, 01 May 2008 15:57:45 -0400" Date: Thu, 01 May 2008 16:34:08 -0400 Message-ID: <25101.1209674048@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/21 X-Sequence-Number: 29105 Geoffrey writes: > Shane Ambler wrote: >> You would have two choices - clean up the data in 7.4 before the export >> or clean up after the import and before the fk constraints are added. > The latter is likely the plan. The primary concern is that we don't > lose any data. There seem to be two possibilities: either the data was actually inconsistent in the 7.4 database (in which case it would be good to find out how it got that way), or the data is fine but the pg_dump script tried to do the ALTER ADD CONSTRAINT too soon (in which case it would be good to find out why pg_dump got confused about that). In either case I'm hoping you still have the 7.4 installation available for inspection ... regards, tom lane