ALTER EXTENSION UPDATE: How to update the 'module_pathname'? - Mailing list pgsql-general

From Henrik Kuhn
Subject ALTER EXTENSION UPDATE: How to update the 'module_pathname'?
Date
Msg-id 50C061C7.3@origenis.de
Whole thread Raw
Responses Re: ALTER EXTENSION UPDATE: How to update the 'module_pathname'?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Hi,

after installing an extension with functions with C bindings - CREATE OR
REPLACE FUNCTION ... AS 'MODULE_PATHNAME' LANGUAGE C ... - I like to
change the 'module_pathname' upon its update. After reading the docs and
especially the section of 'ALTER EXTENSION' I have the feeling, that
this operation is not possible.

First tries lead to the assumption, that the control-file is not
re-parsed in order to reflect any changes in the 'module_pathname'. I'm
correct with my observation?
Is this 'module_pathname' somewhere stored in the internals of some
pg_tables? If yes, it should be possible to update this entry and call
ALTER EXTENSION UPDATE again.

What I do not want to do is a DELETE/CREATE EXTENSION process.

Any suggestions?

Regards,
Henrik



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trigger / constraint issue
Next
From: Henrik Kuhn
Date:
Subject: Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'