How to implement nested transactions - Mailing list pgsql-general

From Andrus
Subject How to implement nested transactions
Date
Msg-id drb3ue$4gk$1@news.hub.org
Whole thread Raw
Responses Re: How to implement nested transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I want to implement nest transactions like

begin;
  CREATE temp table t2 (foo char(20) primary key);
  begin;
    CREATE temp table t1 (bar char(20) primary key);
    commit;
  rollback;

I'm expecting that t1 and t2 tables are not created since last rollback
rolls back its nested transaction.

However, both tables are created.

Any idea hot to force parent transaction rollback to roll back committed
nested transactions ?

Andrus.



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Access Problem After Version Upgrade -- FIXED
Next
From: Rich Shepard
Date:
Subject: Re: Access Problem After Version Upgrade -- FIXED