X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B992D9FA43C for ; Sat, 22 Jul 2006 11:42:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 47049-03 for ; Sat, 22 Jul 2006 14:42:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx3.surnet.cl (mx3.surnet.cl [216.155.73.182]) by postgresql.org (Postfix) with ESMTP id 9233D9FA25B for ; Sat, 22 Jul 2006 11:42:28 -0300 (ADT) Received: from 201-221-221-58.bk12-dsl.surnet.cl (HELO alvh.no-ip.org) ([201.221.221.58]) by mx3.surnet.cl with ESMTP; 22 Jul 2006 10:42:25 -0400 X-IronPort-AV: i="4.07,171,1151899200"; d="scan'208"; a="26670423:sNHT19302968" Received: by alvh.no-ip.org (Postfix, from userid 1000) id 6F706C5CDC2; Sat, 22 Jul 2006 10:42:18 -0400 (CLT) Date: Sat, 22 Jul 2006 10:42:18 -0400 From: Alvaro Herrera To: Martin Marques Cc: pgsql-sql@postgresql.org Subject: Re: Rows with exclusive lock Message-ID: <20060722144218.GH5125@surnet.cl> Mail-Followup-To: Martin Marques , pgsql-sql@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.043 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: ** X-Archive-Number: 200607/287 X-Sequence-Number: 25861 Martin Marques escribió: > Is it posible to get an exclusive (read/write) lock on certain rows? I > don't want to block the whole table, only certain rows, but I want it to > be a read/write lock. That's what SELECT FOR UPDATE does. > AFAIK SELECT FOR UPDATE doesn't help with this. Why? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.