RE: INSERT [IGNORE] INTO TABLE

Поиск
Список
Период
Сортировка
От K Parker
Тема RE: INSERT [IGNORE] INTO TABLE
Дата
Msg-id DHOKJJIEIENOBAAA@shared1-mail.whowhere.com
обсуждение исходный текст
Ответ на INSERT [IGNORE] INTO TABLE  (Petr Jezek <jez20um@axpsu.fpf.slu.cz>)
Список 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 по дате отправления:

Предыдущее
От: Najm Hashmi
Дата:
Сообщение: Re: INSERT [IGNORE] INTO TABLE
Следующее
От: "George Henry C. Daswani"
Дата:
Сообщение: Problem with coalesce..