From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: "Expiring" transactions? |
Date: | 2003-09-25 14:20:20 |
Message-ID: | 3F72F9A4.10307@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bruce Momjian wrote:
> Egor Shipovalov wrote:
>
>>Is there a way to make transaction automatically COMMIT or ROLLBACK after
>>certain period of time?
>>I want website visitors to be able to page through search results using
>>single cursor. Since users can leave the site at any time, I can't know when
>>to end their transaction.
>>
>>I guess I can write a broker that gives each user a connection and tracks
>>when he's gone, performing necessaty cleanup, but isn't there a simplier
>>way?
>
>
> We have statement_timeout, but not transaction_timeout.
Could be nice have it, once I forgot to do a commit and I
left my desk, the day after all the DB was hanged by that opened
transaction.
Regards
Gaetano Mendola.
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-09-25 14:43:48 | Re: "Expiring" transactions? |
Previous Message | scott.marlowe | 2003-09-25 14:17:36 | Re: [GENERAL] PostgreSQL at OSCON 2004 |