On Thu, 03 Sep 2026 at 21:17, "cca5507" <[email protected]> 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.
