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

From Lincoln Yeoh
Subject Re: PREPARE TRANSACTION and webapps
Date
Msg-id 5.2.1.1.1.20051115233048.027fc100@localhost
Whole thread Raw
In response to Re: PREPARE TRANSACTION and webapps  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: PREPARE TRANSACTION and webapps
Re: PREPARE TRANSACTION and webapps
List pgsql-general
Hi,

Can we have a reconnect and "reopen prepared/saved transactions" feature?

Please? :)

I'm sure there'll be uses for it. e.g. the stuff I mentioned.

Maybe we can also use it to help migrate queries to a different node.

At 11:54 AM 11/12/2005 +0800, Lincoln Yeoh wrote:

>At 02:22 PM 11/11/2005 +0100, Martijn van Oosterhout wrote:
>
>>But once you've prepared a transaction, you can't reopen it, all you
>>can do is either commit it or abort it. I don't see how prepared
>>transaction relate to webapps at all.
>>
>>See also the docs:
>>http://www.postgresql.org/docs/8.1/static/sql-prepare-transaction.html
>
>Oh. I thought one could reopen transactions. Why can't we do that? ;)



pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: A good postgresql book
Next
From: Judicaël Dehotin
Date:
Subject: recovering windows database after crash