| From: | Aaron Spiteri <azzmosphere(at)gmail(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Postgres Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Command execution |
| Date: | 2008-07-03 13:37:17 |
| Message-ID: | 7D7A7A2D-AF6C-4082-82E9-FECC551FF84C@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cinu | 2008-07-03 14:26:56 | Switching between terminals |
| Previous Message | Csaba Nagy | 2008-07-03 13:27:44 | Re: Command execution |