skip duplicate key error during inserts

From: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: skip duplicate key error during inserts
Date: 2006-10-20 15:01:50
Message-ID: 20061020150150.14462.qmail@web35301.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I have a table like this:
create table dummy (value integer primary key);
and I insert a row like this
insert into dummy values(0);
then I want to insert three rows:
insert into dummy values(0);
insert into dummy values(1);
insert into dummy values(2);

none of them will be inserted because the first insert is a primary key violation. How can I have postgreSQL not mind about the error and proceed to the next insert. I could send the inserts one at a time but bundling them speeds up the process.
Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2006-10-20 15:09:31 Upgrade 7.4 to 8.1 or 8.2?
Previous Message Shane Ambler 2006-10-20 14:50:35 Re: why not kill -9 postmaster