Re: Curosity question regarding "LOCK" NOWAIT

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Curosity question regarding "LOCK" NOWAIT
Date: 2012-09-22 04:08:21
Message-ID: 505D39B5.6040203@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/21/12 7:43 PM, David Johnston wrote:
> 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?

is this a feature in any other major databases?

is this in the sql spec?

what do you expect to happen if these timeouts expire? return an error,
and abort the transaction?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-09-22 04:11:25 Question about upgrading extensions
Previous Message David Johnston 2012-09-22 02:43:40 Curosity question regarding "LOCK" NOWAIT