lock row in table

From: Daniel Michał <danielosch(at)o2(dot)pl>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: lock row in table
Date: 2003-08-28 08:23:58
Message-ID: 002301c36d3d$baf7f1f0$2601a8c0@gliwice.helion.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hallo everybody,
I have a problem that I can not to solve in a simple way.

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yudha Setiawan 2003-08-28 10:42:50 Re: lock row in table
Previous Message Bruno Wolff III 2003-08-28 03:42:33 Re: smallfloat with postgresql