Re: [SQL] lock row in table

2003-08-28 Thread Tom Lane
=?iso-8859-2?Q?Daniel_Micha=B3?= <[EMAIL PROTECTED]> writes: > I have to lock one row in table1 for user1. In the same time other users sh= > ould 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= >

Re: [SQL] lock row in table

2003-08-28 Thread Daniel
Hi, No, I am sure that I can get this message from Delphi. Check it on web site www.microolap.com For example when I try to put a non-unique value in a primary key I get message from database that I get conflict with primary key :-) of course I use raise ... except ... but everything work perfe

Re: [SQL] lock row in table

2003-08-28 Thread Yudha Setiawan
  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 i

[SQL] lock row in table

2003-08-28 Thread Daniel Michał
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 ha