Re: transactions in functions, possible bug or what I'm doing - Mailing list pgsql-sql

From Tom Lane
Subject Re: transactions in functions, possible bug or what I'm doing
Date
Msg-id 29318.1100884130@sss.pgh.pa.us
Whole thread Raw
In response to Re: transactions in functions, possible bug or what I'm doing  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Michael Fuhr <mike@fuhr.org> writes:
> On Fri, Nov 19, 2004 at 12:59:07PM +0000, Richard Huxton wrote:
>> You can have what are called "savepoints" in version 8.0 though, which 
>> lets you trap errors and rollback to a named (saved) point in your function.

> Savepoints in functions don't work as of 8.0.0beta4, unless I'm
> doing something wrong:

You can't use explicit savepoint commands, but the exception syntax does
essentially the same thing implicitly.
        regards, tom lane


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: transactions in functions, possible bug or what I'm doing
Next
From: Don Drake
Date:
Subject: NULLS and string concatenation