Re: Nested transactions

Scott Marlowe wrote:

On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <pg@dbginc.com> wrote: 

Does PostgreSQL support nested transactions as shown below?

BEGIN;
 ...do some stuff...
 BEGIN;
  ...more stuff...
 COMMIT;
COMMIT;   

Postgresql uses savepoints.

 

Savepoints do not provide the same functionality as nested or parallel transactions because you cannot commit a savepoint. If  I need a second transaction I can always open a second connection so it is easy to get the behavior I need. Thanks.

Bill