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

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Simple SQL INSERT to avoid duplication failed: why?
Date: 2013-05-04 23:44:23
Message-ID: km46gn$2qh$1@gonzo.reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2013-05-01, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-05-04 23:50:57 Re: Associative array in Pl/PgSQL
Previous Message Karel Riveron Escobar 2013-05-04 23:40:48 Associative array in Pl/PgSQL