Thread: Nested Transactions in 7.5??

Nested Transactions in 7.5??

From
Jim Rosenberg
Date:
How realistic is it to expect nested transactions to make it into
PostgreSQL 7.5?

I can't think of anything I've heard of in the works for 7.5 that comes
close in importance -- with the possible exception of a native Windows
port. There are just *so many* cases where you want to be able to have a
stored procedure that spans multiple transactions -- having nested
transactions allows saving a whole architecture tier. Without them,
important aspects of business logic either have to be on the client (where
they don't belong) or you have to have a 3-tier architecture, which adds a
lot to the complexity of the system.

Re: Nested Transactions in 7.5??

From
Tom Lane
Date:
Jim Rosenberg <jr@amanue.com> writes:
> How realistic is it to expect nested transactions to make it into
> PostgreSQL 7.5?

I wouldn't hold my breath.  It's a complex problem.

            regards, tom lane