Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B2451632532 for ; Tue, 12 May 2009 18:26:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53459-06 for ; Tue, 12 May 2009 18:26:16 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 80FA76324B5 for ; Tue, 12 May 2009 18:26:16 -0300 (ADT) X-Greylist: delayed 00:12:57.33768 by SQLgrey-1.7.6 Received: from outmail137145.authsmtp.co.uk (outmail137145.authsmtp.co.uk [62.13.137.145]) by mx3.hub.org (Postfix) with ESMTP id 02C9337BCEC for ; Tue, 12 May 2009 18:26:15 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n4CLCuZL014479; Tue, 12 May 2009 22:12:56 +0100 (BST) Received: from [192.168.0.2] (85-211-96-202.dyn.gotadsl.co.uk [85.211.96.202]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n4CLCsew071128; Tue, 12 May 2009 22:12:54 +0100 (BST) Subject: Re: [COMMITTERS] pgsql: Fix LOCK TABLE to eliminate the race condition that could make it From: Simon Riggs To: Tom Lane Cc: pgsql-hackers@postgresql.org In-Reply-To: <9820.1242162624@sss.pgh.pa.us> References: <20090512164332.BFC1575407D@cvs.postgresql.org> <1242161438.3843.334.camel@ebony.2ndQuadrant> <9820.1242162624@sss.pgh.pa.us> Content-Type: text/plain Date: Tue, 12 May 2009 22:15:26 +0100 Message-Id: <1242162926.3843.339.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: a91252df-3f39-11de-aecc-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaQdbYFhI HGQLW11EUl97WGF/ bg4fZQBDYEtPQQxs TkpJQE1QEQdtHhxP WBptLmoxIkJGf39x Z04sX3JYWAorfEd/ R0wAQ3AFM2RpdWEe BBVFJlYHIx5Kfh5N bVEqXXANN2FJBC9q VzwYGBUUHAljBR5u d0kVIkkLRRRDMD8s DzQlNhZnIWQvYwh7 MxtuJ1odGUcXO1k/ eUchVBoCOhQfaGxV GEdBATNYIF9JWyoi EUtRWlMaHHVYSCRR Shw0Sigg X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:1562/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/546 X-Sequence-Number: 138088 On Tue, 2009-05-12 at 17:10 -0400, Tom Lane wrote: > Simon Riggs writes: > > If we're going to require cascaded permissions like this, would it make > > sense to make GRANT cascade down the inheritance tree also? > > That's been discussed before. I forget whether we decided it was a good > idea or not, but in any case it looks like a new feature not a bug fix. Agreed. I was just trying to think ahead to the implications and difficulties of the LOCK and TRUNCATE changes and see if anything else important emerged. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support