On Thu, Oct 10, 2024 at 3:40 PM Erik Wienhold <ewie(at)ewie(dot)name> wrote:
> On 2024-10-10 14:35 +0200, Dominique Devienne wrote:
> > Hi. Why isn't the ::regrole::text cast working as usual?
> > Aren't the OIDs for grantor and grantee returned by acldefault() valid ROLEs?
>
> You must call acldefault() with spcowner instead of oid:
>
> aclexplode(coalesce(spcacl, acldefault('t', spcowner)))
Rah, silly me. Thanks Erik, much better now. --DD