> On 20/04/2023 00:50 CEST Jay Stanley <beans...@cruzio.com> wrote: > > postgres=# alter table my_schema.my_table drop partition > "my_schema"."my_schema.my_table_should_not_work"; > ERROR: syntax error at or near ""my_schema"" > LINE 1: alter table my_schema.my_table drop partition "my_schema"."m... > ^ > -or- > postgres=# alter table my_schema.my_table drop partition > my_schema."my_schema.my_table_should_not_work"; > ERROR: syntax error at or near "my_schema" > LINE 1: alter table my_schema.my_table drop partition my_schema."my_...
The command you're looking for is ALTER TABLE DETACH PARTITION. DROP PARTITION means dropping the column named "partition". The syntax error comes from the parser expecting an optional CASCADE or RESTRICT after DROP PARTITION. -- Erik
