Обсуждение: Inherited tables cannot be partitioned (version 12.0)

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

Inherited tables cannot be partitioned (version 12.0)

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/ddl-inherit.html
Description:

In the document pages for Inheritance and partitions, it could be worth
mentioning that an inherited table cannot be partitioned.
I tried to apply a 2 levels partitioning with a first level driven by
business rationale and a second automatically managed by hash.
But a command like: 
'create table Data_Biz_Segment () inherits(Data) partition by hash(id)' is
refused by Postgres.