Re: lock - feedback

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