Inherited tables cannot be partitioned (version 12.0)

Started by PG Bug reporting formabout 6 years ago1 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.