Hi,

I was wondering, is it a possibility/projected to have nested transactions
in postgres? Would MVCC support that?

What I would like is following:
begin tran a;
  do some work;
  begin tran b;
    do some other work
  rollback b;
<at this point, only changes by transaction b are rolled back>
... 
commit a;

Alternatively, is there a way to trap an exception in plpgsql? [I would
assume that depends on SPI ability to trap exceptions...]

These features are really needed for people who do serious
database-backend scripting, to compete with sybase (who has multilevel
transactions) and oracle (who has very good exception handling).

Thank you

 -alex


Sun, 8 Oct 2000 23:36:23 -0400 (EDT)
Alex Pilosov <alex@pilosoft.com>
newbieish exception/multilevel transactions