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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Rynell Wesson 2000-11-22 22:51:28 Re: DESC
Previous Message Mike Castle 2000-11-22 19:20:32 Re: DESC