From: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
To: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Possible bug acldefault function
Thread-Topic: Possible bug acldefault function
Thread-Index: AQHbmMt1KnKx88wmYEGqG29aoo180Q==
Date: Wed, 19 Mar 2025 12:49:14 +0000
Message-ID: 
 <AM9P251MB0330304DEEE7015DEFBAB9D098D92@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: AM9P251MB0330:EE_|AS1P251MB0560:EE_
x-ms-office365-filtering-correlation-id: 7f5e2552-067a-4440-8054-08dd66e47485
x-microsoft-antispam: 
 BCL:0;ARA:14566002|9400799030|15080799006|19110799003|7092599003|12050799009|14030799003|8062599003|12121999004|461199028|8060799006|1602099012|4302099013|440099028|3412199025|10035399004|102099032;
x-microsoft-antispam-message-info: 
 =?us-ascii?Q?DeH3Zwp1YQ7BhWP33ANZJz40vilF2+vsnwOgJuYi3EVD8JJY1B80FDFYgyAT?=
 =?us-ascii?Q?Isol/GjqWVw7sQC8ZdSmBdOFadMBe/hufK2dWqBTis92CuK3npA19nYTnW3o?=
 =?us-ascii?Q?3ElJ9Qpfp3PtWVxFp0H3/kWYqu+JlL6WE0KPJp7upu81lGx3CaB2qEZzce80?=
 =?us-ascii?Q?p1mTjLwpgo//SQxcKjKk/Ri5SViLFzbClTXnZ/5z1ZIjoPuSYRckbm2P9qLn?=
 =?us-ascii?Q?H9Oa+SKIiWS9RSrGwdjCxHW8x31Z0NW1v1uOfnkNruuK8QdEoNGc6WaRiKhO?=
 =?us-ascii?Q?VSdN2IG808RHwCcxv3XgIHYxgrfHB6kwsJX9Cy7nbMnrMtq8cxfpMl9z1k8n?=
 =?us-ascii?Q?j8gl2BwUb4a1JAlkKXDyP4CZO1cYgkoom8tcGCSS+aAYVtsuItr2jxOGoRLv?=
 =?us-ascii?Q?fNKUfQl0Ux/KlJl8syHcDc/KCEJmI7bfDwgm2jROYeSesE/DwNSAEx4bOv8P?=
 =?us-ascii?Q?VpR5c6JHVzrPOIzy6IAMmY4Y7j6C4BkjfzCqCttl6LUB778Df7Woo9W2DcFV?=
 =?us-ascii?Q?rKuyCgIcvTMFjcJjfH4S5PioxtWaCmdv3KRlOuGytaBMMIrkUJ12HjuR3gzf?=
 =?us-ascii?Q?83ImGbBMComDSfZ6nHuTR82dyVCneYajPpMSrwBbm9j9ud+zsrHdTxnJ2Yzu?=
 =?us-ascii?Q?T3GUivkGmovEk9eiwWpPDN19dT4eOHQAl7iP0aHulwONuCSYWCDq1agUBDGV?=
 =?us-ascii?Q?h8n+qMsXn4IJJFq+Pd+tfdgDpE8t8EgQsxDMBZ/J0xj0/+IDDtWzM7Ad0dgK?=
 =?us-ascii?Q?9LPDwlIC6q1460VkUhZ0PtgEhuWFhQgoMlSg+YVhcp8vvX9ps+QesylU78RD?=
 =?us-ascii?Q?rttMTI7GQTuViKw3Q3R0EI6MGb0FMlmsYQVoKCQIDeOswYJJ6dLmvgxd5FBx?=
 =?us-ascii?Q?KQr4LYXk/OkO/NgKeLDBbYBmPeh2tXSZLse45bpdVNlbqfUaZ6v309LIr9zW?=
 =?us-ascii?Q?Qg+58KD/MLWKSSz3R1XVJ8GeUTQhXrwIdrWRZ/rA/AWnAjvhdfITTWdDWywn?=
 =?us-ascii?Q?UX54LRzv4VM4fNHjfwLpRVWC3TpCdNyYu1WQibgJfw0G0Ukzqezi4MeCacq0?=
 =?us-ascii?Q?2SUclYWJ9sA2Q9CP1EMzbHGkLRQbgZ1IPli5VRlpMho/hxNSdn4Aoe+GuhzF?=
 =?us-ascii?Q?bmY6kyoHPF3gCmgAl+JmcE25RIZz8bsAgwmRseeh6F90lA4i/0SXaumU7sNQ?=
 =?us-ascii?Q?+aCtzJgQeDaWJ9DyAj8fJ8fwCvmrG+JGiC+4Ago9GmxDC4LTQxygVKkP012R?=
 =?us-ascii?Q?5WU/dnDVxjqXm1CScokRkOEbem3StwlfZleEtK8M9NOulAU1wMZVTK0I9gr1?=
 =?us-ascii?Q?FAvaL7UkxtO+Q2Sxr3z4YtqZZ0Yr8s6J134DoBBYAuEXMKFATZ7zQm6Q04WE?=
 =?us-ascii?Q?Ry9rz7E=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?oj/EGGte+jrS3wf6uiPIujCkiXQ5uw1AGDYOBo8bHTRZRktzXvxXT79c2tO5?=
 =?us-ascii?Q?12O8sdIQs6IBsmUE/hU92/tjRnZQsY3CLv4v64Ioq61QhVLxC+7RsgpwGVb3?=
 =?us-ascii?Q?ldlAgo2wYjAZc338CEWXT/XhKY7gOhyTHoK4HCslwkt//gJ2HhlB1XMAwnMW?=
 =?us-ascii?Q?C4dUDWKCM/911ErCIO9A3hzkl6MC3deyUQaB2nM45a+eN2eaGg2PaRXycfh/?=
 =?us-ascii?Q?JDpuEQ5aIjBU9Vqb2BrZ0cCRuY21vSeYEznVgxPUINAh1hORY+dP7rVdRNyb?=
 =?us-ascii?Q?01u0v4W/Wf97OmaEz4A+Q5JgmmqtYjQMtECK/VArZLBJH4mqs1d5QZ46Ykc1?=
 =?us-ascii?Q?nzNWlqvrbozsFa8qwtQbwN2xKuRIQ2wY2/lOOUeN3pB4GcsVO2rWlqKpXHvr?=
 =?us-ascii?Q?eak7h1Fhj2TSx3bq3aHgujlRxKV0LilwjZnn/mKd65kOohe8qGERK+I9I5U/?=
 =?us-ascii?Q?4O1tzIW13l0yJlXj5xt05MRauz0YCi5DDReoHewhLhgBw7qDQ48N4NRV4TE7?=
 =?us-ascii?Q?YmRtet1sC+J2OKf3CeKz+/4xaekcsZTS+Z0Z9GJnkb6TwRqyAVWLJE91fdqr?=
 =?us-ascii?Q?r8XX7TeUlqUDXL9ffJ1ulvPX8Eb4aae1Vd8yAJDzxv6VM8tzvZEFiWvRMalm?=
 =?us-ascii?Q?rGh8onu+YsCZt/LdyaUYt5RG866vB0tfArL83QvbWqsSlmsWHbto/ppgPcmW?=
 =?us-ascii?Q?5sx3e21jeAfMKezVlyPVNR4s5rVX+Dca0GRlFcgZnYjU+PrGCH9uUH/uU1mX?=
 =?us-ascii?Q?CWBkEMwAqt7HDSajJXil7gRfLCDseRR9xfHP7Jch9eUSoNqPXowU45YqAfCG?=
 =?us-ascii?Q?LxA4vUpob+UlHTDAk1B9gaIOD8/XZ1lOI/pQfzzzR40HyeoTWl+sqt/DhLnq?=
 =?us-ascii?Q?jbKO83yvXohgYhRunebDVK6vORxwAysO4mND106bQ6Beanwf9PfoQQ6r6491?=
 =?us-ascii?Q?2UX6kNiX4Xj1KG7Whhjld80CSmbSTYrM8G1Pc+j89GOnULxaIDn3fBwmZL2s?=
 =?us-ascii?Q?QncQQF8ePirqXYOKAQgy4Bph4tHq7ls90MAdfNoPxqvJ8zbbCELUAdkqOuL3?=
 =?us-ascii?Q?BD3Zc0WycwT/kXgxf4yDoKazVAoe4fJJH1+Kk0E5bTzDCpR4YwvT/JDJSG3u?=
 =?us-ascii?Q?U9W3ZpfNQU7FsnbHdPGRz7kJw4DuuEI+04TkK+v7rVz/pYFNF5QzgV0Xv7S0?=
 =?us-ascii?Q?aIsFD/w8hn/H1y9g62PA5X64XL4qSLgZpHeeuH5qNk6EITkNAOMObWi6gxKt?=
 =?us-ascii?Q?sVAlDNs3hC4mdG9YNypJaMXuKxKT0Z/Si3/Pl4MOjw=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_AM9P251MB0330304DEEE7015DEFBAB9D098D92AM9P251MB0330EURP_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-00b75.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 7f5e2552-067a-4440-8054-08dd66e47485
X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Mar 2025 12:49:14.9735
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1P251MB0560
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/AM9P251MB0330304DEEE7015DEFBAB9D098D92%40AM9P251MB0330.EURP251.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_AM9P251MB0330304DEEE7015DEFBAB9D098D92AM9P251MB0330EURP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Team,

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

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


Please note that the value of relacl column in pg_class is NULL, upon assig=
ning 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>

--_000_AM9P251MB0330304DEEE7015DEFBAB9D098D92AM9P251MB0330EURP_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body>
<div dir=3D"auto">Hi Team,</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">I came across an issue while working with acldefault func=
tion on materialized view, which threw an error &quot;ERROR: unrecognized o=
bjtype abbreviation: m&quot;, when I looked at the source code of acldefaul=
t_sql it seems that materialized view case is
 not handled there, the SQL statement which I was executing is as follows,<=
/div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">`select relname, relowner, acldefault(relkind, relowner) =
as acl from pg_class where relkind in ('r', 'p', 'v', 'm');`</div>
<div id=3D"ms-outlook-mobile-body-separator-line" dir=3D"auto"><br>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Please note that the value of relacl column in pg_class i=
s NULL, upon assigning the permission explicitly the error goes away.</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">I'm not sure if it is truly a bug or I have some misunder=
standing about the function.</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Your guidance will be helpful to get better understanding=
 of the issue.</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Thank you.</div>
</div>
<div dir=3D"auto">
<div dir=3D"auto"><br>
</div>
</div>
<div id=3D"ms-outlook-mobile-signature" dir=3D"auto">Get <a href=3D"https:/=
/aka.ms/AAb9ysg">
Outlook for Android</a></div>
</body>
</html>

--_000_AM9P251MB0330304DEEE7015DEFBAB9D098D92AM9P251MB0330EURP_--