Nested Transactions in 7.5??

Started by Jim Rosenbergover 22 years ago2 messagesgeneral
Jump to latest
#1Jim Rosenberg
jr@amanue.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jim Rosenberg (#1)
Re: Nested Transactions in 7.5??

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