Re: Curosity question regarding "LOCK" NOWAIT - Mailing list pgsql-general

From Boszormenyi Zoltan
Subject Re: Curosity question regarding "LOCK" NOWAIT
Date
Msg-id 505D68D2.9010801@cybertec.at
Whole thread Raw
In response to Curosity question regarding "LOCK" NOWAIT  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Hi,

2012-09-22 04:43 keltezéssel, David Johnston írta:

Has there been any discussion regarding adding a time-limited version of NOWAIT, say: “WAITONLY 50” (milliseconds), when dealing the explicit LOCK TABLE or the SELECT…FOR(SHARE|UPDATE) commands?

 

David J.


we have a proposed patch for 9.3 at
http://archives.postgresql.org/message-id/50339B3D.8040403@cybertec.at
that adds "SET lock_timeout = N;" to have a time-limited wait for locks.

Best regards,
Zoltán Böszörményi

-- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de    http://www.postgresql.at/

pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Curosity question regarding "LOCK" NOWAIT
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: Curosity question regarding "LOCK" NOWAIT