Not able to access Module_Pathname and Unable to drop pg_ivm Extension

[Mahantesh091]

HI After creating the extension ,

(I have attached a text file abt the issue we are facing)

We tried to create ivm_visible_in_prestate this function but getting below error

CREATE FUNCTION ivm_visible_in_prestate(oid, tid, oid)
RETURNS bool
STABLE
AS 'MODULE_PATHNAME', 'ivm_visible_in_prestate'
LANGUAGE C;
2025-01-02 15:56:42.886 IST [1494281] ERROR: could not access file "MODULE_PATHNAME": No such file or directory
2025-01-02 15:56:42.886 IST [1494281] STATEMENT: CREATE FUNCTION ivm_visible_in_prestate(oid, tid, oid)
RETURNS bool
STABLE
AS 'MODULE_PATHNAME', 'ivm_visible_in_prestate'
LANGUAGE C;
ERROR: could not access file "MODULE_PATHNAME": No such file or directory

###########################################################################################
And also i am not able drop the extension

db1=# DROP EXTENSION IF EXISTS pg_ivm CASCADE;
2025-01-02 15:57:04.771 IST [1494281] ERROR: could not open relation with OID 24803
2025-01-02 15:57:04.771 IST [1494281] STATEMENT: DROP EXTENSION IF EXISTS pg_ivm CASCADE;
NOTICE: drop cascades to 32 other objects
DETAIL: drop cascades to trigger IVM_trigger_ins_before_24906 on table orders_new
drop cascades to trigger IVM_trigger_del_before_24907 on table orders_new
drop cascades to trigger IVM_trigger_upd_before_24908 on table orders_new
drop cascades to trigger IVM_trigger_truncate_before_24909 on table orders_new
drop cascades to trigger IVM_trigger_ins_before_32893 on table mv_base_a
drop cascades to trigger IVM_trigger_del_before_32894 on table mv_base_a
drop cascades to trigger IVM_trigger_upd_before_32895 on table mv_base_a
drop cascades to trigger IVM_trigger_truncate_before_32896 on table mv_base_a
drop cascades to trigger IVM_trigger_ins_before_32901 on table mv_base_b
drop cascades to trigger IVM_trigger_del_before_32902 on table mv_base_b
drop cascades to trigger IVM_trigger_upd_before_32903 on table mv_base_b
drop cascades to trigger IVM_trigger_truncate_before_32904 on table mv_base_b
drop cascades to trigger IVM_trigger_ins_after_24910 on table orders_new
drop cascades to trigger IVM_trigger_del_after_24911 on table orders_new
drop cascades to trigger IVM_trigger_upd_after_24912 on table orders_new
drop cascades to trigger IVM_trigger_truncate_after_24913 on table orders_new
drop cascades to trigger IVM_trigger_ins_after_32897 on table mv_base_a
drop cascades to trigger IVM_trigger_del_after_32898 on table mv_base_a
drop cascades to trigger IVM_trigger_upd_after_32899 on table mv_base_a
drop cascades to trigger IVM_trigger_truncate_after_32900 on table mv_base_a
drop cascades to trigger IVM_trigger_ins_after_32905 on table mv_base_b
drop cascades to trigger IVM_trigger_del_after_32906 on table mv_base_b
drop cascades to trigger IVM_trigger_upd_after_32907 on table mv_base_b
drop cascades to trigger IVM_trigger_truncate_after_32908 on table mv_base_b
drop cascades to trigger IVM_prevent_immv_change_24915 on table mv_orders_new_summary
drop cascades to trigger IVM_prevent_immv_change_24916 on table mv_orders_new_summary
drop cascades to trigger IVM_prevent_immv_change_24917 on table mv_orders_new_summary
drop cascades to trigger IVM_prevent_immv_change_24918 on table mv_orders_new_summary
drop cascades to trigger IVM_prevent_immv_change_32909 on table mv_ivm_1
drop cascades to trigger IVM_prevent_immv_change_32910 on table mv_ivm_1
drop cascades to trigger IVM_prevent_immv_change_32911 on table mv_ivm_1
drop cascades to trigger IVM_prevent_immv_change_32912 on table mv_ivm_1
ERROR: could not open relation with OID 24803

pg_ivm .txt

[yugo-n]

CREATE FUNCTION ivm_visible_in_prestate(oid, tid, oid)
...
ERROR: could not access file "MODULE_PATHNAME": No such file or directory

This cannot be installed by executing CREATE FUNCTION directly. You have to use CREATE EXTENSION, or ALTER EXTENSION UPDATE if an old version of pg_ivm is installed. If you have installed pg_ivm 1.9 successfully and still are facing this error, unfortunately I am not sure the cause of it. Maybe, you need to install pg_ivm again.

And also i am not able drop the extension

This is a bug of pg_ivm 1.9, which is fixed by #97.
To drop pg_ivm, remove pg_ivm from preload_shared_libraries, and execute DROP EXTENSION before executing any functions of pg_ivm. Or, update the extension to the up-to-date code in the repository using ALTER EXTENSION UPDATE.