Re: grant execute on many functions

From: Doug Quale <quale1(at)charter(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: grant execute on many functions
Date: 2004-06-30 09:03:26
Message-ID: 87oen1quxt.fsf@charter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debs 2004-06-30 09:42:43 recovery from server crash
Previous Message Gaetano Mendola 2004-06-30 08:43:51 Re: How to list what queries are running in postgres?

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2004-06-30 09:44:35 ODBC Developers
Previous Message Mark Kirkwood 2004-06-30 08:27:49 Compile Failue on win32 - pipe.c using ereport