| From: | Carlos Santos <carloscompels(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | LOCK command inside a TRANSACTION |
| Date: | 2007-04-03 12:48:41 |
| Message-ID: | 141386.39515.qm@web57105.mail.re3.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wilkinson, Jim | 2007-04-03 13:04:00 | Using a variable as a view name in a select |
| Previous Message | Gary Stainburn | 2007-04-03 12:25:50 | best way: diary functions. |