Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2F926636E7B for ; Tue, 16 Jun 2009 15:18:46 -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 26007-01-3 for ; Tue, 16 Jun 2009 15:18:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from phoenix.advel.cz (phoenix.advel.cz [81.0.239.26]) by mail.postgresql.org (Postfix) with SMTP id DA8CF635A2A for ; Tue, 16 Jun 2009 15:15:08 -0300 (ADT) Received: (qmail 7086 invoked from network); 16 Jun 2009 20:16:27 +0200 Received: from unknown (HELO ?10.12.0.96?) (88.103.48.48) by 192.168.1.50 with SMTP; 16 Jun 2009 20:16:27 +0200 Message-ID: <4A37E122.8070303@pjmodos.net> Date: Tue, 16 Jun 2009 20:14:58 +0200 From: Petr Jelinek User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: PostgreSQL-development Subject: Re: GRANT ON ALL IN schema References: <4A37BF63.50008@pjmodos.net> In-Reply-To: <4A37BF63.50008@pjmodos.net> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.15 tagged_above=0 required=5 tests=AWL=0.150 X-Spam-Level: X-Archive-Number: 200906/1026 X-Sequence-Number: 140081 Petr Jelinek wrote: > Anyway back to my thoughts about this patch. First of all I see problem > with the proposed syntax. For this syntax I think TABLES (FUNCTIONS, > SEQUENCES, etc) would have to be added to keywords which is problematic > because there are views named tables, sequences, views in > information_schema so we can't really make them keywords. I have no idea > how to get around this and I don't see good alternative syntax either. > This is main and only real problem I have. Erm, seems like the problem was just me overlooking something in gram.y (I forgot to add those keywords to unreserved_keyword) so no real problems, but I'd still like to hear answers to those other questions in my previous email. -- Regards Petr Jelinek (PJMODOS)