Re: Transaction Handling in pl/pgsql?

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Nee(dot)mem(倪明)" <neemem(at)atlas-china(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transaction Handling in pl/pgsql?
Date: 2005-07-14 02:18:06
Message-ID: 42D5CB5E.7040206@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-14 02:58:22 Re: Errors building older versions of PostgreSQL
Previous Message Thomas F. O'Connell 2005-07-14 02:14:09 Re: ERROR: could not open relation