create extension error

[kciftci89]

create extension pg_profile schema profile; command gives error: version 4.1 on postgresql 15

cannot specify default tablespace for partitioned relations SQL state: 0A000

[zubkov-andrei]

Hi, This is a normal (but unexpected) behavior of a Postgres database when you are creating a partitioned table having _defaulttablespace setting defined. _pgprofile extension is using partitioned tables to avoid concurrency during simultaneous samples collection in parallel sessions. You have two workarounds:

• get _defaulttablespace setting undefined. In this case extension tables will be created in pg_default
• If you want it in another tablespace, you should create a database in wanted tablespace without _defaulttablespace setting in it, and then create an extension in that database.