From: Daniel Michał <danielosch@o2.pl>
To: pgsql-sql@postgresql.org
Subject: lock row in table
Date: Thu, 28 Aug 2003 10:23:58 +0200
Message-ID: <002301c36d3d$baf7f1f0$2601a8c0@gliwice.helion.com.pl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: danielosch@o2.pl
Subject: Re: lock row in table
In-Reply-To: <002301c36d3d$baf7f1f0$2601a8c0@gliwice.helion.com.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox