Re: [PATCH] Allow bare library names for non-superuser LOAD

On Thu, 03 Sep 2026 at 21:17, "cca5507" <cca5507(at)qq(dot)com> wrote:
>> According to the documentation [1], this is expected behavior.
>>
>> Non-superusers can only apply LOAD to library files located in $libdir/plugins/ —
>>         the specified filename must begin with exactly that string. 
>
> Yes, I knew that this is the expected behavior, but it's not very convenient for
> non-superusers, right?

Yeah, it's a bit inconvenient.

> Therefore, I would like to propose a patch that allows
> non-superusers to omit the $libdir/plugins/ prefix and let postgres to expand
> it automatically.
>

The $libdir/plugins directory was introduced in commit abc3120e9b2. It
automatically expands for local_shared_libraries, but not for LOAD command.
I'm not sure if that was intentional.

Other than that, it looks good.

> --
> Regards,
> ChangAo Chen

--
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.