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

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

pgsql-hackers by date

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

pgsql-admin by date

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

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