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

Re: lock - feedback

From: Richard Huxton <dev(at)archonet(dot)com>
To: Thomas Rokohl <rokohl(at)raygina(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: lock - feedback
Date: 2005-10-12 11:40:02
Message-ID: 434CF612.8010705@archonet.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thomas Rokohl wrote:
> hi,
> 
> i have a short question and i don't find an answer is the archive.
> i'm using the odbc interface to the db and if i lock rows with
> SELECT FOR UPDATE  and someone else try the same or
> try to read the rows, i will give him a feedback that he must wait or 
> abort.
> The Problem is that the SELECT statement wait without feedback until
> the end of the world if the row is lock.

Actually, it will timeout, and you can set that with PG's configuration 
setting of "statement_timeout". See the "run-time configuration" section 
of the manual for details.

-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-odbc by date

Next:From: Thomas RokohlDate: 2005-10-12 12:02:38
Subject: Re: lock - feedback
Previous:From: Dave PageDate: 2005-10-12 11:18:09
Subject: Re: installer

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