Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Doug Gorley writes: > Perfect, I'm using the following function: > create or replace function fn_sig(p_oid oid) returns text > as $$ > begin > return p_oid::regprocedure; > end; > $$ language plpgsql; > In the following query: > select > pg_namespace.nspname || > '.' || > fn_sig(pg_p

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Perfect, I'm using the following function: create or replace function fn_sig(p_oid oid) returns text as $$ begin return p_oid::regprocedure; end; $$ language plpgsql; In the following query: select pg_namespace.nspname || '.' || fn_sig(pg_proc.oid) from pg_proc inner join pg_name

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Doug Gorley writes: > That looks like exactly what I want. Is there an easy way to cast that > to a string so that I can concatenate it into a GRANT statement? Well, since 8.3 you just cast it to a string ;-) In older versions I'd suggest a plpgsql wrapper function. plpgsql has always been ve

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

That looks like exactly what I want. Is there an easy way to cast that to a string so that I can concatenate it into a GRANT statement? *Doug Gorley* | doug.gor...@gmail.com Tom Lane wrote:

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Doug Gorley writes: > The statement I need to generate is: > revoke all on function public.add(integer, integer) from someuser; > I'm attempting to use the pg_proc table in the system catalogs, and I'm > good up to the point where I need the parameter types. Can anyone give > me a hand with t