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

From Tom Lane
Subject Re: AW: timeout on lock feature
Date
Msg-id 24074.987523717@sss.pgh.pa.us
Whole thread Raw
In response to RE: AW: timeout on lock feature  (Michael Ansley <Michael.Ansley@intec-telecom-systems.com>)
List pgsql-hackers
Michael Ansley <Michael.Ansley@intec-telecom-systems.com> writes:
> Sorry for my forgetfulness (and a search through geocrawler didn't turn up
> anything useful), but what was the problem with something like NOWAIT?
> e.g.: SELECT * FROM a FOR UPDATE NOWAIT;
> where, if the required lock could not be obtained immediately, this
> statement would raise an error.

I have no objection to that ... it does not cover anything except FOR
UPDATE, though, which is probably less general than some of the other
folks want.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michael Ansley
Date:
Subject: RE: AW: timeout on lock feature
Next
From: Jean-Eric Cuendet
Date:
Subject: Authentication with PGSQL