Re: PREPARE TRANSACTION and webapps - Mailing list pgsql-general

From Tom Lane
Subject Re: PREPARE TRANSACTION and webapps
Date
Msg-id 1901.1132119298@sss.pgh.pa.us
Whole thread Raw
In response to Re: PREPARE TRANSACTION and webapps  (Greg Stark <gsstark@mit.edu>)
Responses Re: PREPARE TRANSACTION and webapps  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> What this would actually be useful for is a fair question
>> though --- what's it do that you don't have now?

> I think what they want to do is make the database concept of transactions
> match up 1-1 with their application's concept of transactions. Which may span
> multiple stateless http requests.

[ itch... ]  This seems to me to fly right in the face of the
oft-repeated advice that you don't hold a transaction open while the
user thinks about it, goes off to lunch, vacations in the Bahamas, etc.

The question remains: what problem are we solving that actually
should be solved?

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: PREPARE TRANSACTION and webapps
Next
From: Greg Stark
Date:
Subject: Re: PREPARE TRANSACTION and webapps