Possible bug acldefault function

Поиск
Список
Период
Сортировка
От Inzamam Shafiq
Тема Possible bug acldefault function
Дата
Msg-id AM9P251MB0330304DEEE7015DEFBAB9D098D92@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: Possible bug acldefault function
Список pgsql-bugs
Дерево обсуждения
Hi Team,

I came across an issue while working with acldefault function on materialized view, which threw an error "ERROR: unrecognized objtype abbreviation: m", when I looked at the source code of acldefault_sql it seems that materialized view case is not handled there, the SQL statement which I was executing is as follows,

`select relname, relowner, acldefault(relkind, relowner) as acl from pg_class where relkind in ('r', 'p', 'v', 'm');`


Please note that the value of relacl column in pg_class is NULL, upon assigning the permission explicitly the error goes away.

I'm not sure if it is truly a bug or I have some misunderstanding about the function.

Your guidance will be helpful to get better understanding of the issue.

Thank you.

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