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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group