Thread: nowait

nowait

From
Kiss Zoltán
Date:
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