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

Re: update table with row locking

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Mark <sendmailtomark(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: update table with row locking
Date: 2004-12-23 20:09:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Thu, 2004-12-23 at 13:56, Mark wrote:
> 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 ?

Generally the update itself will lock the table from other updates until
your transaction either commits or rolls back.  OR are you looking for
something like select for update to lock a row to be used to update
another row?

In response to

pgsql-general by date

Next:From: Michael FuhrDate: 2004-12-23 20:33:03
Subject: Re: update table with row locking
Previous:From: MarkDate: 2004-12-23 19:56:26
Subject: update table with row locking

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