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 to add to the other answers, if the INSERT is before the
> UPDATE in
> the function, the function execution stops when the INSERT fails,
> and so
> the UPDATE will never be executed in the first place...
>
> Cheers,
> Csaba.
>
>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
|
