Re: GRANT ON ALL IN schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GRANT ON ALL IN schema
Date
Msg-id 3285.1249918596@sss.pgh.pa.us
Whole thread Raw
In response to Re: GRANT ON ALL IN schema  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: GRANT ON ALL IN schema  (Robert Haas <robertmhaas@gmail.com>)
Re: GRANT ON ALL IN schema  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
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.  I 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...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [PATCH] "could not reattach to shared memory" on Windows
Next
From: "Kevin Grittner"
Date:
Subject: Re: Alpha releases: How to tag