Re: timeout on lock featurey - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: timeout on lock featurey
Date
Msg-id 200104182333.f3INXOx04659@candle.pha.pa.us
Whole thread Raw
In response to Re: timeout on lock feature  (ncm@zembu.com (Nathan Myers))
Responses Re: timeout on lock feature  (ncm@zembu.com (Nathan Myers))
List pgsql-hackers
> What might be a reasonable alternative would be a BEGIN timeout: report 
> failure as soon as possible after N seconds unless the timer is reset, 
> such as by a commit.  Such a timeout would be meaningful at the 
> database-interface level.  It could serve as a useful building block 
> for application-level timeouts when the client environment has trouble 
> applying timeouts on its own.

Now that is a nifty idea.  Just put it on one command, BEGIN, and have
it apply for the whole transaction.  We could just set an alarm and do a
longjump out on timeout.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: CRN article not updated
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: timeout on lock feature