RE: INSERT [IGNORE] INTO TABLE - Mailing list pgsql-sql

From K Parker
Subject RE: INSERT [IGNORE] INTO TABLE
Date
Msg-id DHOKJJIEIENOBAAA@shared1-mail.whowhere.com
Whole thread Raw
In response to INSERT [IGNORE] INTO TABLE  (Petr Jezek <jez20um@axpsu.fpf.slu.cz>)
List pgsql-sql
>Not a good feature for me.

Me neither, but...

>Check existence and then insert or update.

At least once a week I seem to be responding to this exact same suggestion.  Somebody _please_ tell me if I'm the only
onein the whole world who worries about race conditions?  What's wrong with just making sure there's a proper unique
key,and then just inserting the row?  The returned error message will tell you if a failure is due to duplicate key,
missingnon-null column, or an actual disaster.
 



Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com


pgsql-sql by date:

Previous
From: Najm Hashmi
Date:
Subject: Re: INSERT [IGNORE] INTO TABLE
Next
From: "George Henry C. Daswani"
Date:
Subject: Problem with coalesce..