Re: [SQL] LOCK command inside a TRANSACTION

2007-04-03 Thread Peter Eisentraut
Am Dienstag, 3. April 2007 14:48 schrieb Carlos Santos: > - if an user query a select on a table, the rows of the table in the result > of this select can not be updated or deleted by another user until this one > update, delete or discard the changes on those rows. Sounds like SELECT FOR UPDATE.

[SQL] LOCK command inside a TRANSACTION

2007-04-03 Thread Carlos Santos
Hi! I need Postgresql somehow does this for me: - if an user query a select on a table, the rows of the table in the result of this select can not be updated or deleted by another user until this one update, delete or discard the changes on those rows. I've found something about the LOCK command