Re: [PATCH] pg_permissions - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: [PATCH] pg_permissions
Date
Msg-id 75e26115-a70d-4e23-bd3e-1a39c2d8664a@www.fastmail.com
Whole thread Raw
List pgsql-hackers
On Fri, Mar 26, 2021, at 11:30, Alvaro Herrera wrote:
On 2021-Mar-26, Joel Jacobson wrote:

> On Thu, Mar 25, 2021, at 17:51, Tom Lane wrote:

> > I wonder what performance will be like with lots o' objects.

> I guess pg_get_acl() would need to be implemented using a switch(classid) with 36 cases (one for each class)?

No, we have a generalized object query mechanism, see objectaddress.c

That's where I was looking actually and noticed the switch with 36 cases, in the function getObjectDescription().

/Joel

pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: [PATCH] add concurrent_abort callback for output plugin
Next
From: Tomas Vondra
Date:
Subject: Re: PoC/WIP: Extended statistics on expressions