Re: [HACKERS] Command execution

2008-07-03 Thread Aaron Spiteri
Thanks for pointers, that has cleared a few things up for me. On 03/07/2008, at 11:27 PM, Csaba Nagy wrote: On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote: Inside foo there was a INSERT and UPDATE, and the INSERT failed but the UPDATE succeeded would the UPDATE be rolled back? Just t

Re: [HACKERS] Command execution

2008-07-03 Thread Csaba Nagy
On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote: > Inside foo there was a INSERT and UPDATE, and the INSERT failed but > the UPDATE succeeded would the UPDATE be rolled back? Just to add to the other answers, if the INSERT is before the UPDATE in the function, the function execution stops

Re: [HACKERS] Command execution

2008-07-03 Thread A. Kretschmer
am Thu, dem 03.07.2008, um 23:15:33 +1000 mailte Aaron Spiteri folgendes: > Hi guys, > > I have been following the mailing list and reading the source code > for a little while, and was wandering if someone could fill in the > gaps for me. Does PostgresQL view updates and inserts performed

[HACKERS] Command execution

2008-07-03 Thread Aaron Spiteri
Hi guys, I have been following the mailing list and reading the source code for a little while, and was wandering if someone could fill in the gaps for me. Does PostgresQL view updates and inserts performed in a function as part of the same transaction or are they considered separate tr