Re: Locking timeouts

"Robinson, Chad" wrote:
>
> Hello all,
>
> Sorry for what may be a "newbie" question, but I haven't used PostgreSQL
> since the ODBC driver was called PostODBC, not pgsqlodbc, and I can't find
> this answer in the list archives.
>
> I have locking working in an ODBC application, written in VB using
> Connection/Recordset objects, "select ... for update", BeginTrans, and
> Update/CommitTrans to save the data). This correctly blocks other users from
> editing (but not reading) the record being edited. That's what I want.
>
> However, other users attempting to edit the record are blocked until the
> record is released. Normally, a database will release the user with an error
> noting that they were blocked by a record lock. PostgreSQL is not doing
> this.

Yes but it's not an ODBC's problem.

> Can it be made to do so? This is a data entry application, so blocking other
> users until the record is released by the editor is not acceptable.

There seems no easy solution.
How about an optiomistic concurrency control not a pessimistic
one ?

regards,
Hiroshi Inoue