Re: duplicate key violates unique constraint

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: duplicate key violates unique constraint
Дата
Msg-id 1118676122.2720.24.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: duplicate key violates unique constraint  (Richard Huxton <dev@archonet.com>)
Ответы Re: duplicate key violates unique constraint
Список pgsql-general
[snip]
> If you have more than one client, this can always happen. You have two
> choices:
>   1. Use a lock to stop two clients interacting like this

This won't work unless you make all the clients serialized, or you have
all the ip's already inserted in the data base... you can't lock on an
unknown key, otherwise the locking will also need to insert, and you're
back to the same race condition ;-)

Cheers,
Csaba.




В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: mirroring oracle database in pgsql
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: duplicate key violates unique constraint