Обсуждение: Not able to create partition table using partition by list method

Поиск
Список
Период
Сортировка

Not able to create partition table using partition by list method

От
Rajput Vishwas Kumar Shankarbhai
Дата:

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

Вложения

Re: Not able to create partition table using partition by list method

От
Magnus Hagander
Дата:
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.
 
--

Re: Not able to create partition table using partition by list method

От
Michael Paquier
Дата:
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
Вложения

Re: Not able to create partition table using partition by list method

От
Magnus Hagander
Дата:
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.

--