Re: Command execution - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: Command execution
Date
Msg-id 1215091664.2834.123.camel@PCD12478
Whole thread Raw
In response to Command execution  (Aaron Spiteri <azzmosphere@gmail.com>)
Responses Re: Command execution  (Aaron Spiteri <azzmosphere@gmail.com>)
List pgsql-hackers
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.




pgsql-hackers by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Command execution
Next
From: Aaron Spiteri
Date:
Subject: Re: Command execution