| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PREPARE TRANSACTION and webapps |
| Date: | 2005-11-15 15:40:50 |
| Message-ID: | 5.2.1.1.1.20051115233048.027fc100@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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? ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | john.bender | 2005-11-15 16:44:51 | subscribe |
| Previous Message | Robert Treat | 2005-11-15 15:39:27 | Re: A good postgresql book |