Re: SELECT FOR UPDATE NOWAIT

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Paulo Scardine <paulos(at)cimed(dot)ind(dot)br>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SELECT FOR UPDATE NOWAIT
Date: 2003-07-18 19:51:32
Message-ID: 1058557891.31093.24.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2003-07-18 at 19:46, Paulo Scardine wrote:
> My boss is asking for something like Oracle's "SELECT FOR UPDATE NOWAIT".
>
> Is there any such feature? If no, should I look forward into implementing
> this? Any advice?

Lookup STATEMENT_TIMEOUT and set it to a very short time.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message scott.marlowe 2003-07-18 20:02:41 Re: Urgent: 10K or more connections
Previous Message Paulo Scardine 2003-07-18 19:46:50 SELECT FOR UPDATE NOWAIT