DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=tydnqdggBRcjR4UH4R3Bhp26KxhfEDqUpYwOnXXJOwuYRQGdjDSkn77YuprpNxAQNR
	8xegxL6z4uccbLrkuNJQc/XB5r7j+bus/3YE6JGfXuM9yQr1qBPjTf3Oh5jm5j9IIeWk
	Hc5zpReWLEO2dRQK+iiOEUbEzwlXtaRJ3jZ24=
MIME-Version: 1.0
In-Reply-To: <3285.1249918596@sss.pgh.pa.us>
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>
Date: Mon, 10 Aug 2009 12:09:55 -0400
Message-ID: <603c8f070908100909m69b876cdt1723f2fbd2462a40@mail.gmail.com>
Subject: Re: GRANT ON ALL IN schema
From: Robert Haas <robertmhaas@gmail.com>
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>,
	Petr Jelinek <pjmodos@pjmodos.net>, Stephen Frost <sfrost@snowman.net>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, Aug 10, 2009 at 11:36 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> One fairly simple way would use a new SQL verb (say, DO) like this:
>
>> DO $$ something in plfoo $$ LANGUAGE plfoo;
>
> Yeah, this has been suggested before. =A0I can't see anything very wrong
> with it.
>
>> We could even default the langauge to plpgsql, for which you would then
>> just need:
>
>> DO $$ something in plpgsql $$;
>
> Add a GUC variable to set the default language, perhaps?
>
>> 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.
>
> That would be an awful lot of messiness to save four keystrokes...

I think it would be awfully handy to integrate some of the features of
PL/pgsql into core SQL - especially variables, and also things like IF
and FOR...  but I'm not expecting it to happen any time soon, or maybe
ever.

...Robert