Re: grant execute on many functions - Mailing list pgsql-admin

From Tom Lane
Subject Re: grant execute on many functions
Date
Msg-id 3843.1088570281@sss.pgh.pa.us
Whole thread Raw
In response to Re: grant execute on many functions  (Joe Conway <mail@joeconway.com>)
Responses Re: grant execute on many functions  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
Joe Conway <mail@joeconway.com> writes:
>    select 'GRANT EXECUTE ON ' || 1142::regprocedure;
>    ERROR:  array value must start with "{" or dimension information

BTW, it seems like there's something pretty broken here.  How did
arrays get into it?  A quick probe suggests that it is resolving
the above input as array_append for type regprocedure[], which would
qualify as a surprising choice in my book.  7.3 gives a more reasonable
"unable to identify an operator ||" ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: grant execute on many functions
Next
From: Joe Conway
Date:
Subject: Re: grant execute on many functions