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

From Doug Quale
Subject Re: grant execute on many functions
Date
Msg-id 87oen1quxt.fsf@charter.net
Whole thread Raw
In response to Re: grant execute on many functions  (Joe Conway <mail@joeconway.com>)
Responses Re: grant execute on many functions
List pgsql-admin
Joe Conway <mail@joeconway.com> writes:

> That's even better -- I tried regproc, but forgot about
> regprocedure. I think the problem will be, though, that the output of
> the reg* datatypes is not castable to text, and therefore cannot be
> used to build a dynamic sql statement.

This must be why

test=# select oid::regprocedure from pg_proc order by oid::regprocedure;

doesn't sort the way I would expect.


pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: How to list what queries are running in postgres?
Next
From: "Tuttle, Gene"
Date:
Subject: PL/pgSQL