Don't strip $libdir from LOAD command
authorPeter Eisentraut
Wed, 4 Jun 2025 09:21:24 +0000 (11:21 +0200)
committerPeter Eisentraut
Wed, 4 Jun 2025 09:38:12 +0000 (11:38 +0200)
commitf777d773878ddda3388bb18dbcb93e97a0fb52e2
tree0408eb1ee31b196a90cbd19d52a2dfc923431177
parent7f3381c7ee661e552634f06509a3452988a15845
Don't strip $libdir from LOAD command

Commit 4f7f7b03758 implemented the extension_control_path GUC, and to
make it work it was decided that we should strip the $libdir/ on
module_pathname from .control files, so that extensions don't need to
worry about this change.

This strip logic was implemented on expand_dynamic_library_name()
which works fine when executing the SQL functions from extensions, but
this function is also called when the LOAD command is executed, and
since the user may explicitly pass the $libdir prefix on LOAD
parameter, we should not strip in this case.

This commit fixes this issue by moving the strip logic from
expand_dynamic_library_name() to load_external_function() that is
called when the running the SQL script from extensions.

Reported-by: Evan Si
Author: Matheus Alcantara 
Reviewed-by: Nathan Bossart
Reviewed-by: Rahila Syed
Bug: #18920
Discussion: https://www.postgresql.org/message-id/flat/18920-b350b1c0a30af006%40postgresql.org
src/backend/utils/fmgr/dfmgr.c