Re: "Expiring" transactions? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: "Expiring" transactions?
Date
Msg-id 3F72FF24.9020501@persistent.co.in
Whole thread Raw
In response to Re: "Expiring" transactions?  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: "Expiring" transactions?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Gaetano Mendola wrote:

> Bruce Momjian wrote:
>> 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.

Probably it could detect idle time and disconnect.. That could be used to roll
back automatically..

  Shridhar


pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: "Expiring" transactions?
Next
From: Stephan Szabo
Date:
Subject: Re: How to find LIMIT in SQL standard