Re: grant execute on many functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Jean-Denis Giguere <jdenisgiguere(at)fastmail(dot)fm>, pgsql-admin(at)postgresql(dot)org
Subject: Re: grant execute on many functions
Date: 2004-06-30 04:38:01
Message-ID: 3843.1088570281@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Joe Conway <mail(at)joeconway(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2004-06-30 04:45:05 Re: grant execute on many functions
Previous Message Tom Lane 2004-06-30 04:26:17 Re: grant execute on many functions

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2004-06-30 04:45:05 Re: grant execute on many functions
Previous Message Tom Lane 2004-06-30 04:26:17 Re: grant execute on many functions