Skip site navigation (1) Skip section navigation (2)

nowait

From: Kiss Zoltán <kiss(dot)zoltan(at)uze(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: nowait
Date: 2000-11-22 21:00:21
Message-ID: DPG.WIN.300.0011222200213163039708@drotposta.hu (view raw or flat)
Thread:
Lists: pgsql-novice
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

Next:From: Rynell WessonDate: 2000-11-22 22:51:28
Subject: Re: DESC
Previous:From: Mike CastleDate: 2000-11-22 19:20:32
Subject: Re: DESC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group