Command execution - Mailing list pgsql-hackers

From Aaron Spiteri
Subject Command execution
Date
Msg-id 610F90B4-C869-4B70-8DCF-A8A55731F1C1@gmail.com
Whole thread Raw
Responses Re: Command execution  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Command execution  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-hackers
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?


pgsql-hackers by date:

Previous
From: daveg
Date:
Subject: Re: [PATCHES] pg_dump lock timeout
Next
From: Simon Riggs
Date:
Subject: Re: Resolving polymorphic functions with relateddatatypes