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 > Re: Insert with...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 3097 of 3323
Post > Topic >>

Re: Insert with possible constraint violations?

by gentosaker@[EMAIL PROTECTED] ("A B") Apr 30, 2008 at 08:45 AM

>  I'm not sure I have enough knowledge to answer you so I think
>  I'm replying to you personally but I think it would help you get
>  your answer if you described what you would like to do with
>  records that violate the unique(a,b) constraint.
If they violate, just ignore them.  mysql have a insert ignore that
tries to insert and ignore any error and this is just the thing. I
could select and see if it is already there, but that seems a little
unessecery.

-- 
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:
Insert with possible constraint violations?
gentosaker@[EMAIL PROTECT  2008-04-29 09:56:21 
Re: Insert with possible constraint violations?
gentosaker@[EMAIL PROTECT  2008-04-30 08:45:00 

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 5:53:26 CST 2008.