Re: lock - feedback - Mailing list pgsql-odbc

From Merlin Moncure
Subject Re: lock - feedback
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD596@Herge.rcsinc.local
Whole thread Raw
In response to lock - feedback  (Thomas Rokohl <rokohl@raygina.de>)
List pgsql-odbc
>
> sure it is big problem, but i think you can solve it with different
> locking types.
> if you have a write look and no read looks it should work.
> i mean if you never ban the reading of the data but you guarantee with
> write locks
> than only one user can have a record in write-mode everything is fine
> and nothing is slow.
> and this is the point where i want to pop up a dialog with the message
> that someone else edit the record yet.

with user locks I do exactly this.  I develop a ISAM (COBOL) driver for
postgresql with pessimistic locking including ISAM style table locks.
Play with the userlock module and you will find there are various lock
types meeting different criteria.

Merlin

pgsql-odbc by date:

Previous
From: Thomas Rokohl
Date:
Subject: Re: lock - feedback
Next
From: "Merlin Moncure"
Date:
Subject: Re: lock - feedback