pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLOCK command inside a TRANSACTION
2+ messages / 2 participants
[nested] [flat]
* LOCK command inside a TRANSACTION
@ 2007-04-03 12:48 Carlos Santos <carloscompels@yahoo.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Carlos Santos @ 2007-04-03 12:48 UTC (permalink / raw)
To: 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: LOCK command inside a TRANSACTION
@ 2007-04-03 13:57 Peter Eisentraut <peter_e@gmx.net>
parent: Carlos Santos <carloscompels@yahoo.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2007-04-03 13:57 UTC (permalink / raw)
To: pgsql-sql@postgresql.org, Carlos Santos <carlos@compels.net>
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.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-03 13:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-03 12:48 LOCK command inside a TRANSACTION Carlos Santos <carloscompels@yahoo.com.br>
2007-04-03 13:57 ` Peter Eisentraut <peter_e@gmx.net>
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