Michael Banck <michael.ba...@credativ.de> writes: > As I've been bitten by this problem recently, I thought I'd take a look > at editing the PostGIS extension SQL file to this end, but contrary to > the above, the @extschema@ feature only applies to non-relocatable > extensions, from src/backend/commands/extension.c:
> * If it's not relocatable, substitute the target schema name for > * occurrences of @extschema@. > * > * For a relocatable extension, we needn't do this. There cannot be > * any need for @extschema@, else it wouldn't be relocatable. > I'm not sure that logic is sound - even if setting @extschema@ > explicitly in the SQL functions bodies kills inlining (not sure about > that) or wouldn't help for other reasons, ISTM this should be > reconsidered in the light of the use case with materialized views during > restore. It's not simply a matter of allowing the substitution to occur while reading the extension script. "Relocatable" means that we support ALTER EXTENSION SET SCHEMA, which means moving all the extension's objects into some new schema. There's no good way to run around and find places where @extschema@ was replaced in order to change them to something else. Basically the point of @extschema@ is to support extensions that are relocatable at installation time, but not afterwards. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers