Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5AFCC6327BE for ; Wed, 5 Aug 2009 13:41:15 -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 07006-04 for ; Wed, 5 Aug 2009 16:41:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id D8C41632745 for ; Wed, 5 Aug 2009 13:41:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n75GewiZ020811; Wed, 5 Aug 2009 12:40:58 -0400 (EDT) To: Robert Haas cc: Stephen Frost , Nikhil Sontakke , Petr Jelinek , PostgreSQL-development Subject: Re: GRANT ON ALL IN schema In-reply-to: <603c8f070908050932m19e7db65u9dab6d8001c5a237@mail.gmail.com> References: <4A37BF63.50008@pjmodos.net> <4A37E122.8070303@pjmodos.net> <4A38A956.8080600@pjmodos.net> <4A4DE104.8090605@pjmodos.net> <4A6059B4.5010004@pjmodos.net> <4A607997.3030305@pjmodos.net> <603c8f070907191628r6929055coe7627726a33ed143@mail.gmail.com> <603c8f070908050932m19e7db65u9dab6d8001c5a237@mail.gmail.com> Comments: In-reply-to Robert Haas message dated "Wed, 05 Aug 2009 12:32:25 -0400" Date: Wed, 05 Aug 2009 12:40:58 -0400 Message-ID: <20810.1249490458@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/330 X-Sequence-Number: 142973 Robert Haas writes: > My understanding is that this patch will need to be reworked as well > based on Tom's comments on "DefaultACLs". Does that sound right? > Should we expect a new version this week, or defer this until the > September CommitFest? I was planning to go review that patch too, even though it's presumably not committable yet. I'm not sure whether there is consensus on not using GRANT ON VIEW (ie, having these patches treat tables and views alike). I was waiting to see if Stephen would put forward a convincing counterargument ... regards, tom lane