LOCK command inside a TRANSACTION

Поиск
Список
Период
Сортировка
От Carlos Santos
Тема LOCK command inside a TRANSACTION
Дата
Msg-id 141386.39515.qm@web57105.mail.re3.yahoo.com
обсуждение исходный текст
Ответы Using a variable as a view name in a select
Re: LOCK command inside a TRANSACTION
Список pgsql-sql
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 inside a TRANSACTION but I didn't see how I could do that yet.

Does anybody have any ideas?
 
Carlos Henrique Iazzetti Santos
Compels Informática
Santa Rita do Sapucaí - MG
Brazil
www.compels.net


__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/

В списке pgsql-sql по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: best way: diary functions.
Следующее
От: "Wilkinson, Jim"
Дата:
Сообщение: Using a variable as a view name in a select