Обсуждение: ALTER EXTENSION UPDATE: How to update the 'module_pathname'?

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

Henrik Kuhn wrote:
> 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?

I think your problem can be solved by creating a new version of
your extension.  In the update script you can have the
CREATE OR REPLACE FUNCTION statements you need.

Yours,
Laurenz Albe