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

locks and "select for update"

From: Wayne Cuddy <lists-pgsql(at)useunix(dot)net>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: locks and "select for update"
Date: 2012-08-31 17:05:54
Message-ID: 20120831170554.GA32084@slacker.ja10629.home (view raw or flat)
Thread:
Lists: pgsql-sql
The documentation about concurrency states that all the different types
of locks are table locks even if the word row appears in the lock name.

The documentation about select statements states that when "for update
of" is used that only the selected rows will be locked. Is this true or
does this really mean that when any target row is found the entire table
is locked until the end of the transaction?

Thanks,
Wayne


Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2012-08-31 19:28:05
Subject: Re: locks and "select for update"
Previous:From: Yelai, Ramkumar IN BLR STSDate: 2012-08-31 14:55:50
Subject: Need to Iterate the record in plpgsql

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