Message-ID: <4A808A6C.9060602@enterprisedb.com>
Date: Tue, 11 Aug 2009 00:00:28 +0300
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Organization: EnterpriseDB
User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Andrew Dunstan <andrew@dunslane.net>,
	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
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>
In-Reply-To: <3285.1249918596@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> But to make it really nice you'd have to move away from pl programs as 
>> strings. That would be a lot more work, and you really wouldn't want to 
>> make it work with more than one PL for the sake of everyone's sanity.

You mean something like:

postgres=# begin
  ...
end;

?

> That would be an awful lot of messiness to save four keystrokes...

I second that. We support that in EDB for Oracle compatibility, and it's
a pain the ass. You need to call the PL/pgSQL parser on the query string
just to figure out where it ends. And worse, psql needs to know about it
too, so you need a minimal version of the PL/pgSQL parser in the client too.

Something like
DO $$ begin ...; end $$;

gives 90% of the usability with 10% of the trouble.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com