From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | newbieish exception/multilevel transactions |
Date: | 2000-10-09 03:36:23 |
Message-ID: | Pine.BSO.4.10.10010082330420.19791-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Billy G. Allie | 2000-10-09 03:41:38 | Patch to FAQ_SCO for PostgreSQL 7.1 |
Previous Message | Mikheev, Vadim | 2000-10-09 03:30:43 | RE: newbieish exception/multilevel transactions |