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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
