To: Andrew Dunstan <andrew@dunslane.net>
cc: Pavel Stehule <pavel.stehule@gmail.com>,
	Dimitri Fontaine <dfontaine@hi-media.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org,
	Nikhil Sontakke <nikhil.sontakke@enterprisedb.com>,
	Robert Haas <robertmhaas@gmail.com>,
	Petr Jelinek <pjmodos@pjmodos.net>, Stephen Frost <sfrost@snowman.net>
Subject: Re: GRANT ON ALL IN schema 
In-reply-to: <4A86B5D5.6060807@dunslane.net> 
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>
	<2CCE9C1D-919D-45D5-BFC2-C7723C45064E@hi-media.com>
	<162867790908150434j7aef36ecm202e81c4bb4740fa@mail.gmail.com>
	<4A86B5D5.6060807@dunslane.net>
Comments: In-reply-to Andrew Dunstan <andrew@dunslane.net>
	message dated "Sat, 15 Aug 2009 09:19:17 -0400"
Date: Sat, 15 Aug 2009 11:11:21 -0400
Message-ID: <13473.1250349081@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Andrew Dunstan <andrew@dunslane.net> writes:
> Pavel Stehule wrote:
>> why we need DO statement? Why not just $$ $$. Only string literal
>> cannot be statement too, so DO is unnecessary.

> I'm also not sure I want to be trying to execute any arbitrary string 
> that accidentally gets placed there because someone forgot to put a 
> keyword or accidentally deleted it.

That's my feeling as well.  Also, I don't think it is sane to allow
options (like "LANGUAGE foo") on a standalone string constant.  Yeah,
we could persuade bison to do it, but that doesn't make it a good idea.

			regards, tom lane