On Tue, Dec 3, 2019 at 6:18 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Alexander Korotkov <a.korot...@postgrespro.ru> writes: > > But nevertheless should we allow relocatable extension to use > > @extschema@. Any thoughts? > > No. The reasoning in the comment still holds good: if you embed > @extschema@ in an object's definition, it becomes nonrelocatable.
I see, allowing @extschema@ in non-relocatable extension provides easy way to shoot yourself in the foot. However, it might be still useful to be able to distinguish extension and core object in upgrade script of relocatable extensions. What about (optional) way to set search_path to @extschema@, pg_catalog instead of just @extschema@? ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
