Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9BCD8633CAE for ; Mon, 10 Aug 2009 18:07:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 20207-01-8 for ; Mon, 10 Aug 2009 21:07:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from alexis.jtlnet.com (alexis.jtlnet.com [69.36.9.81]) by mail.postgresql.org (Postfix) with ESMTP id 3E0BB635500 for ; Mon, 10 Aug 2009 18:07:39 -0300 (ADT) Received: from [192.168.10.103] (cpe-075-177-154-027.nc.res.rr.com [::ffff:75.177.154.27]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by alexis.jtlnet.com with esmtp; Mon, 10 Aug 2009 17:02:36 -0400 id 000849A7.4A808AEC.00005E36 Message-ID: <4A808C14.6040507@dunslane.net> Date: Mon, 10 Aug 2009 17:07:32 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.0.9-3.fc6 pango-text SeaMonkey/1.0.9 MIME-Version: 1.0 To: Heikki Linnakangas CC: Tom Lane , Kevin Grittner , Peter Eisentraut , pgsql-hackers@postgresql.org, Nikhil Sontakke , Robert Haas , Petr Jelinek , Stephen Frost Subject: Re: GRANT ON ALL IN schema References: <4A37BF63.50008@pjmodos.net> <603c8f070908050951s3e5df452se4c610f01b80bb7d@mail.gmail.com> <21246.1249491592@sss.pgh.pa.us> <200908101042.35024.peter_e@gmx.net> <4A7FE7F902000025000296E3@gw.wicourts.gov> <4A803A89.9020509@dunslane.net> <3285.1249918596@sss.pgh.pa.us> <4A808A6C.9060602@enterprisedb.com> In-Reply-To: <4A808A6C.9060602@enterprisedb.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.369 tagged_above=-10 required=5 tests=AWL=1.230, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/850 X-Sequence-Number: 143493 Heikki Linnakangas wrote: > Something like > DO $$ begin ...; end $$; > > gives 90% of the usability with 10% of the trouble. > > Yes, I think that's the consensus. cheers andrew