| From: | "K Parker" <kparker(at)eudoramail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | RE: INSERT [IGNORE] INTO TABLE |
| Date: | 2000-10-31 19:42:22 |
| Message-ID: | DHOKJJIEIENOBAAA@shared1-mail.whowhere.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 one in 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, missing non-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Henry C. Daswani | 2000-10-31 21:52:41 | Problem with coalesce.. |
| Previous Message | Edmar Wiggers | 2000-10-31 17:19:07 | RE: INSERT [IGNORE] INTO TABLE |