Scott Marlowe <[email protected]> writes:
> On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y <[email protected]> wrote:
>> I still couldn't find that particular line that caused that problem :-(.
>> Counting was very pain.
>> Is there anyway that I can tell psql just to "ignore" (I mean don't insert
>> it duplicate key into unique index users_pkey) and just keep going without
>> doing the PQendcopy:resetting connection?
> Not really directly. What I'd do is remove the unique constraint,
> insert, then use something like
> select max(row_id) from table t1 join table t2 on
> t1.somefield=t2.somefield and t1.row_id<>r2.row_id;
> to find dupes and remove them.
> Then I'd dump the whole db and migrate to a more modern version of pgsql.
If you were using a more modern version of pgsql, it would tell you what
the duplicated key was ;-). So maybe you could try loading the dump
file into something newer as a means of debugging the problem.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
