Re: Curosity question regarding "LOCK" NOWAIT

Boszormenyi Zoltan <zb@xxxxxxxxxxx> · Sat, 22 Sep 2012 09:29:22 +0200



    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@xxxxxxxxxxx

    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/