-----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jasen Betts Sent: May 4, 2013 7:44 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Simple SQL INSERT to avoid duplication failed: why?
On 2013-05-01, Carlo Stonebanks <stonec.regis...@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? It would, but it's not running on a web server. It's a kind of dedicated data warehouse with very limited access. No programs have the right to write to the tables other than the one in question. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
