On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y <mary.y.w...@boeing.com> wrote: > Thanks Tom. > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
