ALTER EXTENSION UPDATE: How to update the 'module_pathname'?

From: Henrik Kuhn <henrik(dot)kuhn(at)origenis(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: ALTER EXTENSION UPDATE: How to update the 'module_pathname'?
Date: 2012-12-06 09:13:43
Message-ID: 50C061C7.3@origenis.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Kuhn 2012-12-06 09:47:20 Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'
Previous Message Tom Lane 2012-12-06 00:13:40 Re: Fwd: question on foreign key lock