Обсуждение: nowait

Поиск
Список
Период
Сортировка

nowait

От
Kiss Zoltán
Дата:
Hi All!

Exist in the PGSQL  Oracle like
SELECT * FROM TABLEX WHERE ID = 12345
 FOR UPDATE NOWAIT  statement???

FOR UPDATE try lock record(s) of table (and wait forever).
NOWAIT if record is locked by another user then create an error.

Thanks for all ideas!

thx
Pepe