Re: Curosity question regarding "LOCK" NOWAIT

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Curosity question regarding "LOCK" NOWAIT
Дата
Msg-id 505D39B5.6040203@hogranch.com
обсуждение исходный текст
Ответ на Curosity question regarding "LOCK" NOWAIT  ("David Johnston" <polobo@yahoo.com>)
Ответы Re: Curosity question regarding "LOCK" NOWAIT  (David Johnston <polobo@yahoo.com>)
Re: Curosity question regarding "LOCK" NOWAIT  (Boszormenyi Zoltan <zb@cybertec.at>)
Re: Curosity question regarding "LOCK" NOWAIT  (Thomas Munro <munro@ip9.org>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Curosity question regarding "LOCK" NOWAIT
Следующее
От: Chris Travers
Дата:
Сообщение: Question about upgrading extensions