ERROR: permission denied for schema pglogical - DDL triggers disabled

[pasolid]

Hi,

I have a problem when I try to drop index.
I don’t have DDL triggers.
I tested doing next:

Scenario that works

• create test_table
• drop test_table

Failing scenario

• create test_table
• create ix_test on test_table
• drop ix_test

Error

SQL Error [42501]: ERROR: permission denied for schema pglogical

What I don’t understand is why when there aren’t explicit DDL triggers, a DROP INDEX specifically failing. Creation of index is working, and even DDL like create/drop table is working.

I know there is an option to gran permissions USAGE on pglogical (like this: GRANT USAGE ON SCHEMA pglogical TO my_user) but it is not desired solution in my case.

Postgres version

AWS RDS
PostgreSQL 16.1
PostgreSQL 16.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit