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

On Thu, 03 Sep 2026 at 20:11, "cca5507" <cca5507(at)qq(dot)com> wrote:
> Hi,
>
> Non-superusers may use LOAD only for libraries located in
> $libdir/plugins, but currently they must specify that directory
> explicitly, for example:
>
> LOAD '$libdir/plugins/mylib';
>

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.

> This differs from local_preload_libraries, which accepts a bare library
> name and automatically prepends $libdir/plugins.
>
> The attached patch moves this expansion from load_libraries() into
> load_file(). As a result, a non-superuser can write:
>
> LOAD 'mylib';
>
> and have it interpreted as:
>
> LOAD '$libdir/plugins/mylib';
>
> Thoughts?
>
> --
> Regards,
> ChangAo Chen

[1] https://www.postgresql.org/docs/current/sql-load.html

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