Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7UfQ-0005qe-W5 for pgsql-sql@postgresql.org; Fri, 31 Aug 2012 17:06:01 +0000 Received: from eastrmfepo102.cox.net ([68.230.241.214]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7UfN-0008Dt-6b for pgsql-sql@postgresql.org; Fri, 31 Aug 2012 17:06:00 +0000 Received: from eastrmimpo109 ([68.230.241.222]) by eastrmfepo102.cox.net (InterMail vM.8.01.04.00 201-2260-137-20101110) with ESMTP id <20120831170555.MCA26743.eastrmfepo102.cox.net@eastrmimpo109> for ; Fri, 31 Aug 2012 13:05:55 -0400 Received: from slacker.ja10629.home ([68.106.109.147]) by eastrmimpo109 with cox id tV5v1j0043Ar1Vg01V5vd4; Fri, 31 Aug 2012 13:05:55 -0400 X-CT-Class: Clean X-CT-Score: 0.00 X-CT-RefID: str=0001.0A020202.5040EEF3.00B6,ss=1,re=0.000,fgs=0 X-CT-Spam: 0 X-Authority-Analysis: v=2.0 cv=G56e4qY5 c=1 sm=1 a=sXZhTwfwSKhiTs9RzZXpNQ==:17 a=z1TLwsU0kBEA:10 a=rkgvU9CJhKwA:10 a=PjkiJtDTOQ4A:10 a=ZcFhQy0-F_sA:10 a=kj9zAlcOel0A:10 a=StQPT0p14t0A:10 a=P6M1L9rJAAAA:8 a=RDeE6T_DEOy11eU7yYsA:9 a=CjuIK1q_8ugA:10 a=sXZhTwfwSKhiTs9RzZXpNQ==:117 X-CM-Score: 0.00 Authentication-Results: cox.net; none Received: from wcuddy by slacker.ja10629.home with local (Exim 4.72) (envelope-from ) id 1T7UfK-0008Nn-Tl for pgsql-sql@postgresql.org; Fri, 31 Aug 2012 13:05:54 -0400 Date: Fri, 31 Aug 2012 13:05:54 -0400 From: Wayne Cuddy To: PostgreSQL Subject: locks and "select for update" Message-ID: <20120831170554.GA32084@slacker.ja10629.home> Mail-Followup-To: PostgreSQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.3i X-Pg-Spam-Score: -0.0 (/) X-Archive-Number: 201208/30 X-Sequence-Number: 36801 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