doc sql-grant.html Synopsis error?

Поиск
Список
Период
Сортировка
От jian he
Тема doc sql-grant.html Synopsis error?
Дата
Msg-id CACJufxFjD1=HzPUYC=03G-iUPtj+_NYHD+qpSfPrjmPz3hyLPQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: doc sql-grant.html Synopsis error?  (Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>)
Список pgsql-general
Дерево обсуждения

Hi.
--work as intended.
grant ALL PRIVILEGES on FUNCTION pg_catalog.pg_reload_conf() to test;
grant ALL PRIVILEGES on FUNCTION pg_reload_conf() to test;

-------------errors. it should be work, or I interpret the doc the wrong way?
GRANT ALL PRIVILEGES ON FUNCTION pg_reload_conf() IN SCHEMA pg_catalog TO test;
GRANT ALL PRIVILEGES ON FUNCTION pg_catalog.pg_reload_conf() IN SCHEMA pg_catalog TO test;

doc: https://www.postgresql.org/docs/current/sql-grant.html
GRANT { EXECUTE | ALL [ PRIVILEGES ] }    ON { { FUNCTION | PROCEDURE | ROUTINE } routine_name [ ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) ] [, ...]         | ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA schema_name [, ...] }    TO role_specification [, ...] [ WITH GRANT OPTION ]    [ GRANTED BY role_specification ]
I am using postgres 16, but the grant function part does not change.
What did I miss?

В списке pgsql-general по дате отправления:

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: pg_ctlcluster is not stopping cluster
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: doc sql-grant.html Synopsis error?