Skip site navigation (1) Skip section navigation (2)

update table with row locking

From: Mark <sendmailtomark(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: update table with row locking
Date: 2004-12-23 19:56:26
Message-ID: 20041223195626.85449.qmail@web40907.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
Is it possible to lock row(s) when updating a table, so another call
for update( from different session) will be rejected and to be on
hold until lock get released ?

Thanks,
Mark.


		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com 

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2004-12-23 20:09:15
Subject: Re: update table with row locking
Previous:From: BamberoDate: 2004-12-23 18:37:14
Subject: select as

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group