Re: Simple SQL INSERT to avoid duplication failed: why?

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Simple SQL INSERT to avoid duplication failed: why?
Дата
Msg-id km46gn$2qh$1@gonzo.reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Simple SQL INSERT to avoid duplication failed: why?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Ответы Re: Simple SQL INSERT to avoid duplication failed: why?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-general
On 2013-05-01, Carlo Stonebanks <stonec.register@sympatico.ca> wrote:
> There are no client poolers (unless pgtcl has one I don't know about) so
> this is unlikely.
>
> The trigger is an interesting idea to try if it happens again - I can't keep
> it for long as it is for a massive cache (used to deflect calls to a web
> service) and will bloat the logs pretty quickly.
>
> I have to ask myself, is it more likely that I have discovered some PG
> anomaly in 9.0 that no one has ever noticed, or that the client has
> accidentally launched the process twice and doesn't know it?

If it's running on a web server and two clients send the same request
simultaneously could that cause it to try the same task twice
simultaneously?

--
⚂⚃ 100% natural

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Associative array in Pl/PgSQL
Следующее
От: Karel Riveron Escobar
Дата:
Сообщение: Re: Associative array in Pl/PgSQL