Re: lock row in table

From: "Yudha Setiawan" <inas_husband(at)bonbon(dot)net>
To: Daniel Michał <danielosch(at)o2(dot)pl>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: lock row in table
Date: 2003-08-28 10:42:50
Message-ID: 1bb201c36d51$2728f500$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel 2003-08-28 12:14:38 Re: lock row in table
Previous Message Daniel Michał 2003-08-28 08:23:58 lock row in table