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

• Transactions within a function body at 2008-10-01 15:54:01 from Reg Me Please

Responses

• Re: Transactions within a function body at 2008-10-02 00:34:42 from Alvaro Herrera

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