From: | Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com> |
---|---|
To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Possible bug acldefault function |
Date: | 2025-03-19 12:49:14 |
Message-ID: | AM9P251MB0330304DEEE7015DEFBAB9D098D92@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
Get Outlook for Android<https://aka.ms/AAb9ysg>
From | Date | Subject | |
---|---|---|---|
Next Message | Yoni Sade | 2025-03-19 13:34:48 | Re: BUG #18854: PostgreSQL chooses a suboptimal execution plan when using a specific WHERE filter |
Previous Message | Amit Langote | 2025-03-19 03:16:54 | Re: BUG #18830: ExecInitMerge Segfault on MERGE |