On Wed, Oct 1, 2008 at 5:54 PM, Reg Me Please <regmeplease(at)gmail(dot)com> wrote:
> Hi all.
> Is there a way to have (sub)transactions within a function body?
> I'd like to execute some code (a transaction!) inside a function and later
> decide whether that transaction is to be committed or not.
You could issue a "SAVEPOINT name". If at the end you don't want your
changes to apply, you can issue a "ROLLBACK to name"
In response to
pgsql-hackers by date
|Next:||From: pgsql||Date: 2008-10-01 21:51:33|
|Subject: Re: Block-level CRC checks|
|Previous:||From: Tom Lane||Date: 2008-10-01 20:16:13|
|Subject: Re: Block-level CRC checks |
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2008-10-01 21:38:57|
|Subject: Re: inserting only new rows from csv file|
|Previous:||From: Seb||Date: 2008-10-01 21:16:44|
|Subject: inserting only new rows from csv file|