Avoiding Postgres Extensions Limitations
Postgres extensions are great. They enable fantastic use cases and bring new capabilities to one of the most loved open source databases. But there are edges in some of its features and this can be heard in conversations: limitations of the upgrade system, lack of parameterized initialization, search path/OID resolution issues, hard-wired dependency on .control
files, schema droppage 1, etc.
However, the beauty of it is that what we ultimately want from extensions does not need to use CREATE EXTENSION
's framework.