Re: Command execution

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Aaron Spiteri <azzmosphere(at)gmail(dot)com>
Cc: Postgres Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Command execution
Date: 2008-07-03 13:27:44
Message-ID: 1215091664.2834.123.camel@PCD12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aaron Spiteri 2008-07-03 13:37:17 Re: Command execution
Previous Message Simon Riggs 2008-07-03 13:24:06 Re: Resolving polymorphic functions with relateddatatypes