Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
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
Hi,
I have a problem when I try to drop index. I don’t have DDL triggers. I tested doing next:
Scenario that works
Failing scenario
Error
SQL Error [42501]: ERROR: permission denied for schema pglogicalWhat 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