Re: Nested transactions

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Bill Todd <pg(at)dbginc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Nested transactions
Date: 2009-10-12 02:50:22
Message-ID: 4AD2996E.8000608@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Todd wrote:
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
> ...more stuff...
> COMMIT;
> COMMIT;

no, but in recent versiosn, you can use SAVEPOINT to achieve much the
same effect.

http://www.postgresql.org/docs/current/static/sql-savepoint.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hunsberger 2009-10-12 03:01:52 Re: table full scan or index full scan?
Previous Message Scott Marlowe 2009-10-12 02:45:01 Re: Nested transactions