From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
---|---|
To: | "'Alex Pilosov'" <alex(at)pilosoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | RE: newbieish exception/multilevel transactions |
Date: | 2000-10-09 03:30:43 |
Message-ID: | 8F4C99C66D04D4118F580090272A7A23018D40@SECTORBASE1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Savepoints will be implemented after WAL.
Vadim
> 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 | Alex Pilosov | 2000-10-09 03:36:23 | newbieish exception/multilevel transactions |
Previous Message | Alfred Perlstein | 2000-10-09 02:54:59 | Re: Still crashing with latest 7.0.2 (Re: (forw) more crashes) |