search

2ndQuadrant / pglogical

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.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

Cannot Drop Unlogged Table #176

Open glk1001 opened 6 years ago

glk1001 commented 6 years ago

With pglogical extension 2.1.1 installed on Postgres 9.5.9, and using a non-superuser user, after

create logged table junk(f1 char(10);

I get a pglogical schema permission error with

drop table junk;

This seemed to be covered in the closed issue #15 and the commit ec458646 but I can't find any "GRANT USAGE ON SCHEMA pglogical TO public" line in any of the sql in releases 2.n. What should the behaviour be?

joulaud commented 5 years ago

Same here on "TRUNCATE" operation (Insufficient privilege: 7 ERROR: permission denied for schema pglogical: TRUNCATE {cache_block} ;) with pglogical 2.2.1-4.pgdg80+1 on PostgreSQL 9.5. We worked around by adding the GRANT manually.

luannnh commented 5 years ago

Same here, ERROR: permission denied for schema pglogical , and worked around by grant usge on schema pglogical to public. We are using Postgres 9.4 and pglogical 2.2.0.