Re: Add pg_get_acl() function get the ACL for a database object

Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: Add pg_get_acl() function get the ACL for a database object
Дата
Msg-id CAMsGm5deS=Qk9OHK_jCOBOpt=RHb2UxKdXfCeXzPoi_yjwiSVA@mail.gmail.com
обсуждение исходный текст
Ответ на Add pg_get_acl() function get the ACL for a database object  ("Joel Jacobson" <joel@compiler.org>)
Ответы Re: Add pg_get_acl() function get the ACL for a database object
Список pgsql-hackers
Дерево обсуждения
On Wed, 19 Jun 2024 at 07:35, Joel Jacobson <joel@compiler.org> wrote:
Hello hackers,

Currently, obtaining the Access Control List (ACL) for a database object
requires querying specific pg_catalog tables directly, where the user
needs to know the name of the ACL column for the object.

I have no idea how often this would be useful, but I wonder if it could work to have overloaded single-parameter versions for each of regprocedure (pg_proc.proacl), regclass (pg_class.relacl), …. To call, just cast the OID to the appropriate reg* type.

For example: To get the ACL for table 'example_table', call pg_get_acl ('example_table'::regclass)

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

Предыдущее
От: "Joel Jacobson"
Дата:
Сообщение: Re: Add pg_get_acl() function get the ACL for a database object
Следующее
От: Alexander Pyhalov
Дата:
Сообщение: Re: Inconsistency between try_mergejoin_path and create_mergejoin_plan