I
I
Igor_Petrovv2020-05-25 21:12:28
PostgreSQL
Igor_Petrovv, 2020-05-25 21:12:28

How to make an extension relocatable?

I made such a decision, to move the extension - control--1.0.sql (I created the code for determining the waiting mat through create schema) and send control--1.0.control to SHAREDIR/extension and specify relocatable= in the control--1.0.control file true. And in response received corrections:

answer is not correct.
Try to create your extension in a clean database.
Create a new DB.
Create a test schema;
Do
create extension complex with schema test;
Now make it work.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-05-25
@Igor_Petrovv

created via create schema

this is only possible if the extension contains no internal assumptions about what schema any of its objects are in

How to make an extension roamable?
where did create schema come from in your sql, any references to it in object names

Well, there cannot be any create schema or links to them in the relocatable extension.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question