Postgres Pro
Downloads
Home   >   mailing lists

Re: Not able to create partition table using partition by list method - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: Not able to create partition table using partition by list method
Date
Msg-id CABUevExwEwtWtrKxpL4+F49mV5FFkdN8nmv7xaJUPotWtdP2wA@mail.gmail.com
Whole thread Raw
In response to Not able to create partition table using partition by list method  (Rajput Vishwas Kumar Shankarbhai <Rajput_Vishwas@infosys.com>)
Responses Re: Not able to create partition table using partition by list method
List pgsql-bugs
Tree view
On Thu, Jun 13, 2019 at 10:01 AM Rajput Vishwas Kumar Shankarbhai <Rajput_Vishwas@infosys.com> wrote:

Hi,

 

While creating a partition table using partition by list method, I came across some unusual thing.

I have google for this problem but not find any such reports.

 

Please find attached document on detailed description and error message.

 


It loos like you are using EnterpriseDB specific partitioning syntax but using PostgreSQL as your database. Basically, you are reading the wrong documentation.

See the PostgreSQL documentation at https://www.postgresql.org/docs/10/ddl-partitioning.html and https://www.postgresql.org/docs/10/sql-createtable.html for the syntax to use in PostgreSQL, including examples.
 
--

pgsql-bugs by date:

Previous
From: Rajput Vishwas Kumar Shankarbhai
Date:
Subject: Not able to create partition table using partition by list method
Next
From: Michael Paquier
Date:
Subject: Re: Not able to create partition table using partition by list method