Not able to create partition table using partition by list method

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.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;

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

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.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;