Thread: Not able to create partition table using partition by list method
Not able to create partition table using partition by list method
From
Rajput Vishwas Kumar Shankarbhai
Date:
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.
Thanks,
Vishwas
Attachment
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.
On Thu, Jun 13, 2019 at 10:04:59AM +0200, Magnus Hagander wrote: > It loos like you are using EnterpriseDB specific partitioning syntax but > using PostgreSQL as your database. Basically, you are reading the wrong > documentation. If you can see something specific to vanilla Postgres, then let's see it. -- Michael
Attachment
On Thu, Jun 13, 2019 at 10:11 AM Michael Paquier <michael@paquier.xyz> wrote:
On Thu, Jun 13, 2019 at 10:04:59AM +0200, Magnus Hagander wrote:
> It loos like you are using EnterpriseDB specific partitioning syntax but
> using PostgreSQL as your database. Basically, you are reading the wrong
> documentation.
If you can see something specific to vanilla Postgres, then let's see
it.
I don't understand what you're saying here.
The syntax the OP used was from EnterpriseDBs oracle compatibility layer, as indicated by the document. That is completely different from PostgreSQL syntax.