Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about accessing partitions whose name includes the schema name and a period - is this correct? - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about accessing partitions whose name includes the schema name and a period - is this correct?
Date
Msg-id 3066833.1681963414@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about accessing partitions whose name includes the schema name and a period - is this correct?  (Jay Stanley <beansboy@cruzio.com>)
List pgsql-general
Tree view 
Jay Stanley <beansboy@cruzio.com> writes:
> However, it's failing on partition-management SQL like:

> 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...
>                                                        ^

I'm not sure why the error cursor is pointing there, but
"drop partition" is not a valid subcommand.  Try "detach
partition".

            regards, tom lane

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..."
Next
From: Laurenz Albe
Date:
Subject: Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..."