Re: Transaction Handling in pl/pgsql? - Mailing list pgsql-general

From Neil Conway
Subject Re: Transaction Handling in pl/pgsql?
Date
Msg-id 42D5CB5E.7040206@samurai.com
Whole thread Raw
In response to Re: Transaction Handling in pl/pgsql?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Joshua D. Drake wrote:
> If you are using savepoints you can rollback to a specific point of
> a parent transaction.

Although you can't use savepoints (explicitly) in functions. PL/PgSQL
exceptions (which are actually implemented internally via savepoints)
can be used to achieve a similar effect.

-Neil

pgsql-general by date:

Previous
From: Tim Allen
Date:
Subject: Re: chosing a database name
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: ERROR: could not open relation