Обсуждение: postgresql and lock an row
Hallo everybody,
I have a problem that I can not to solve in a simple way. I wrote a message to pgsql-sql@postgresql.org but "I can get no satisfaction". Maybe You help me please :-)....
This is my problem....
SOME INFORMATION:
I have a postgresql database version 7.2.2 on Linux platform. I communicate with Postgresql from a Delphi application using microolap drivers and everything works fine.
PROBLEM DESCRIPTION:
I have to lock one row in table1 for user1. In the same time other users should be able to read this record but when other user for example user2 want to edit this record user2 should get information "The row you try to edit is currently edit" - or sometihing similar.
Of course I can lock record with syntax "Begin; select * from table1 where ID=12 for update; update table1 set field1="New value" where ID=12; commit;"
but I can not to inform other user that the record is edited?
MAIN TARGET:
How to get information that current record is edited? Which function can I use?
Please help me, Maybe someone have similar problem?
Greetings,
Daniel