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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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