Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

Next:From: Joe ConwayDate: 2004-06-30 04:45:05
Subject: Re: grant execute on many functions
Previous:From: Tom LaneDate: 2004-06-30 04:26:17
Subject: Re: grant execute on many functions

pgsql-admin by date

Next:From: Joe ConwayDate: 2004-06-30 04:45:05
Subject: Re: grant execute on many functions
Previous:From: Tom LaneDate: 2004-06-30 04:26:17
Subject: Re: grant execute on many functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group