Inherited tables cannot be partitioned (version 12.0)

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: franck(dot)vallee(at)contentserv(dot)com
Subject: Inherited tables cannot be partitioned (version 12.0)
Date: 2020-03-10 10:26:51
Message-ID: 158383601150.5709.7549872568270044567@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Browse pgsql-docs by date

  From Date Subject
Next Message Corey Huinker 2020-03-10 15:37:41 Re: Add A Glossary
Previous Message Bruce Momjian 2020-03-10 02:50:26 Re: Users/Roles do not align.