pg_tle icon indicating copy to clipboard operation
pg_tle copied to clipboard

Support `@extschema:name@`

Open jkatz opened this issue 3 years ago • 0 comments

Describe the problem

Extensions that have dependencies on other extensions need awareness of what schema the dependent extension is installed into. However, it may not be possible to install dependent extensions into other schemas, particularly when an extension is relocatable.

Describe the proposal

https://github.com/postgres/postgres/commit/72a5b1fc880481914da2d4233077438dd87840ca (targeted PostgreSQL 16) added a new substitution, @extschema:name@, that allows inserting the schema name of a required extension to simplify cross-extension references.

Describe alternatives

A user set up their extensions so that they are in the appropriate reference schema.

jkatz avatar Apr 16 '23 00:04 jkatz