> 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.
pgsql-odbc by date
|Next:||From: Joseph Armbruster||Date: 2005-10-12 19:34:58|
|Subject: vb6 inquiry|
|Previous:||From: Thomas Rokohl||Date: 2005-10-12 15:38:16|
|Subject: Re: lock - feedback|