Re: GRANT ON ALL IN schema

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

Kevin Grittner wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> wrote: 
>  
>   
> > This would become much simpler if you could just execute plpgsql
> > code instead of having to define a function around it.
> >     
>  
> I have often wished for that feature.
>  
>   

You're not Robinson Crusoe.

It could be done in several ways.

One fairly simple way would use a new SQL verb (say, DO) like this:

DO $$ something in plfoo$ $ LANGUAGE plfoo;

We could even default the langauge to plpgsql, for which you would then 
just need:

DO $$ something in plpgsql $$;

The something would in effect be treated as a throwaway function taking 
no parameters and returning void.

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.

cheers

andrew