Re: lock row in table

Поиск
Список
Период
Сортировка
От Yudha Setiawan
Тема Re: lock row in table
Дата
Msg-id 1bb201c36d51$2728f500$ea00a8c0@yudha
обсуждение исходный текст
Ответ на lock row in table  (Daniel Michał <danielosch@o2.pl>)
Ответы Re: lock row in table
Список pgsql-sql
 
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?
 
* as long as i know, the only message you could create is just
raise notice 'ur_message'; or raise exception 'ur_error_message';
* and the only message that delphi could read is just raise exception.
 
* And if you wanna make your own message, perhaps you must using try and except
* and you could give your own message via ShowMessage('ur_message') or other
* Class object on delphi.
 
 
Please help me, Maybe someone have similar problem?
Greetings,
Daniel
 
Hope it Help, GOD Bless You and Bravo PostgreSQL.

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

Предыдущее
От: Daniel Michał
Дата:
Сообщение: lock row in table
Следующее
От: "Daniel"
Дата:
Сообщение: Re: lock row in table