Re: Simple SQL INSERT to avoid duplication failed: why? - Mailing list pgsql-general

From Jasen Betts
Subject Re: Simple SQL INSERT to avoid duplication failed: why?
Date
Msg-id km46gn$2qh$1@gonzo.reversiblemaps.ath.cx
Whole thread Raw
In response to Simple SQL INSERT to avoid duplication failed: why?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: Simple SQL INSERT to avoid duplication failed: why?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Associative array in Pl/PgSQL
Next
From: Karel Riveron Escobar
Date:
Subject: Re: Associative array in Pl/PgSQL