From: Tom Lane <tgl@sss.pgh.pa.us>
To: Geoffrey <lists@serioustechnology.com>
Cc: Shane Ambler <pgsql@Sheeky.Biz>
Cc: pgsql-admin@postgresql.org
Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1
Date: Thu, 01 May 2008 16:34:08 -0400
Message-ID: <25101.1209674048@sss.pgh.pa.us> (raw)
In-Reply-To: <481A20B9.3000403@serioustechnology.com>
References: <4819EDF9.2080000@serioustechnology.com>
<481A09B8.2070604@Sheeky.Biz>
<481A20B9.3000403@serioustechnology.com>
Geoffrey <lists@serioustechnology.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, lists@serioustechnology.com, pgsql@Sheeky.Biz
Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1
In-Reply-To: <25101.1209674048@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox