Re: [HACKERS] timeout on lock featurey

2001-04-18 Thread Bruce Momjian
> 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 appl

Re: AW: [HACKERS] timeout on lock featurey

2001-04-18 Thread Bruce Momjian
[ 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 RESE