Postgres Pro
Downloads
Home   >   mailing lists

nowait - Mailing list pgsql-novice

From Kiss Zoltán
Subject nowait
Date
Msg-id DPG.WIN.300.0011222200213163039708@drotposta.hu
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Mike Castle
Date:
Subject: Re: DESC
Next
From: Rynell Wesson
Date:
Subject: Re: DESC