Home > mailing lists

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

From	pasman pasmański
Subject	Re: isn't "insert into where not exists" atomic?
Date	February 3, 2011 20:35:22
Msg-id	AANLkTik-h=DHus2naKwCi9mmmN3=n0Q3d5LHMA7+8J8X@mail.gmail.com Whole thread Raw
In response to	isn't "insert into where not exists" atomic? (Mage <mage@mage.hu>)
Responses	Re: isn't "insert into where not exists" atomic? (Mage <mage@mage.hu>)
List	pgsql-general

Your trigger is wrong. You try to insert the same row twice.

From: Alban Hertroys
Date: 03 February 2011, 19:10:06
Subject: Tip: Transposing rows using generate_series()

From: pasman pasmański
Date: 03 February 2011, 20:44:28
Subject: Re: Tip: Transposing rows using generate_series()