Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Ignore unique v...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 3051 of 3322
Post > Topic >>

Ignore unique violations?

by gentosaker@[EMAIL PROTECTED] ("A B") Mar 27, 2008 at 09:45 AM

Is there any easy way of ignoring unique violations?
I have a table (a integer, b integer, unique (a,b) ) and want to
insert pairs of values for a and b, but I do not want to first select
to see if there is a pair  before inserting.
So can I make postgres ignore any error or exception?

The inserts are placed inside of a transaction and I really don't want
any silly error to abort it.

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 2 Posts in Topic:
Ignore unique violations?
gentosaker@[EMAIL PROTECT  2008-03-27 09:45:33 
Re: Ignore unique violations?
richard.broersma@[EMAIL P  2008-03-27 05:50:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 4:19:04 CST 2008.