postgresql and lock an row

Поиск
Список
Период
Сортировка
От Daniel Michał
Тема postgresql and lock an row
Дата
Msg-id 002201c36d5f$efd76fa0$2601a8c0@gliwice.helion.com.pl
обсуждение исходный текст
Список pgsql-admin
Дерево обсуждения
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
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mauri Sahlberg
Дата:
Сообщение: plpgsql: Bush becomes a null, can not execute null query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql: Bush becomes a null, can not execute null query