Thomas Rokohl wrote:
> 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
> 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.
In response to
pgsql-odbc by date
|Next:||From: Thomas Rokohl||Date: 2005-10-12 12:02:38|
|Subject: Re: lock - feedback|
|Previous:||From: Dave Page||Date: 2005-10-12 11:18:09|
|Subject: Re: installer|