Re: isn't "insert into where not exists" atomic? - Mailing list pgsql-general

From Mage
Subject Re: isn't "insert into where not exists" atomic?
Date
Msg-id 4D4F06F4.4090209@mage.hu
Whole thread Raw
In response to Re: isn't "insert into where not exists" atomic?  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
On 02/04/2011 06:57 AM, pasman pasmański wrote:
> Mage, add "raise notice" at the begin of your buggy trigger.
>
There is a little bit of difference between "Your trigger is wrong. You
try to insert the same row twice" and "The trigger will be fired twice."

You stated the first but the second is the truth.

Nevermind, my solution will be using table level lock for this case.

         Mage



pgsql-general by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: Looking for Suggestion on Learning
Next
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: "could not accept SSPI security context"