Search Postgresql Archives

How to implement nested transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux