Skip site navigation (1) Skip section navigation (2)

Re: Insert with possible constraint violations?

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Insert with possible constraint violations?
Date: 2008-04-30 06:45:00
Message-ID: dbbf25900804292345o2f34dc66oece8de2e7ddf9e18@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
>  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.

In response to

pgsql-novice by date

Next:From: Phillip SmithDate: 2008-05-01 00:29:28
Subject: Re: - Advice about hardware configuration
Previous:From: fouratDate: 2008-04-30 01:21:58
Subject: fourat wants to keep up with you on Twitter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group