Re: isn't "insert into where not exists" atomic?

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