Re: Command execution

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 in a  
> function as part of the same transaction or are they considered  
> separate transactions:
> 
> For instance say I had a function name foo and ran the command:
> 
> SELECT foo();
> 
> Inside foo there was a INSERT and UPDATE, and the INSERT failed but  
> the UPDATE succeeded would the UPDATE be rolled back?

The whole function is an own transaction. Fails the INSERT, the complete
function foo failed. In other words; yes, also the UPDATE rolled back.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net