Re: Nested transactions - Mailing list pgsql-general

From John R Pierce
Subject Re: Nested transactions
Date
Msg-id 4AD2996E.8000608@hogranch.com
Whole thread Raw
In response to Nested transactions  (Bill Todd <pg@dbginc.com>)
List 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



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Nested transactions
Next
From: Peter Hunsberger
Date:
Subject: Re: table full scan or index full scan?