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

From Bruce Momjian
Subject Re: AW: timeout on lock featurey
Date
Msg-id 200104182013.f3IKDSd19112@candle.pha.pa.us
Whole thread Raw
In response to RE: AW: timeout on lock feature  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
[ Charset ISO-8859-1 unsupported, converting... ]
> > One idea Tom had was to make it only active in a transaction, 
> > so you do:
> > 
> >     BEGIN WORK;
> >     SET TIMEOUT TO 10;
> >     UPDATE tab SET col = 3;
> >     COMMIT
> > 
> > Tom is concerned people will do the SET and forget to RESET 
> > it, causing all queries to be affected by the timeout.
> 
> And what? Queries would be just aborted. It's not critical event
> to take responsibility from user.

Hey, I agree.  If the users wants the TIMEOUT, give it to them.

--  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: Bruce Momjian
Date:
Subject: Re: Another news story in need of 'enlightenment'
Next
From: Tom Lane
Date:
Subject: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore