2012-09-22 06:08 keltezéssel, John R Pierce írta:
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?
Yes, at least Informix has it in the form of SET LOCK MODE TO { NOT WAIT | WAIT
[N] }.
is this in the sql spec?
No.
what do you expect to happen if these timeouts expire? return an error, and abort the
transaction?
--
----------------------------------
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/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
