From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: franck.vallee@contentserv.com
Subject: Inherited tables cannot be partitioned (version 12.0)
Date: Tue, 10 Mar 2020 10:26:51 +0000
Message-ID: <158383601150.5709.7549872568270044567@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, franck.vallee@contentserv.com
Subject: Re: Inherited tables cannot be partitioned (version 12.0)
In-Reply-To: <158383601150.5709.7549872568270044567@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox