Re: grant execute on many functions

Поиск
Список
Период
Сортировка
От Doug Quale
Тема Re: grant execute on many functions
Дата
Msg-id 87oen1quxt.fsf@charter.net
обсуждение исходный текст
Ответ на Re: grant execute on many functions  (Joe Conway <mail@joeconway.com>)
Ответы Re: grant execute on many functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: How to list what queries are running in postgres?
Следующее
От: "Tuttle, Gene"
Дата:
Сообщение: PL/pgSQL