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 03:45:14
Message-ID: 3318.1088567114@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Joe Conway <mail(at)joeconway(dot)com> writes:
> Jean-Denis Giguere wrote:
>> But, the problem is more complex for functions because you have to give 
>> the arguments.

> Does this help?

> SELECT n.nspname || '.' || p.proname ||
>         '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'

Also, casting the function's OID to regprocedure may be useful.
Random example:

regression=# select 1142::regprocedure;
      regprocedure
------------------------
 date_mii(date,integer)
(1 row)

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Joe ConwayDate: 2004-06-30 04:20:02
Subject: Re: grant execute on many functions
Previous:From: Tom LaneDate: 2004-06-30 03:19:51
Subject: Re: lock timeout patch

pgsql-admin by date

Next:From: Joe ConwayDate: 2004-06-30 04:20:02
Subject: Re: grant execute on many functions
Previous:From: Tom LaneDate: 2004-06-30 03:37:22
Subject: Re: How to list what queries are running in postgres?

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