Table Partitioning

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: jph(at)openjph(dot)be
Subject: Table Partitioning
Date: 2020-07-30 13:33:29
Message-ID: 159611600912.679.16677937108598917950@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-partitioning.html
Description:

With version 12 using declarative partitioning request that the column used
for patitioning is part of the PRIMARY KEY of the table as you can see in
the error message below.

ERROR: insufficient columns in PRIMARY KEY constraint definition
DETAIL: PRIMARY KEY constraint on table "ztest" lacks column "mtime" which
is part of the partition key.

If I've well understood, this was not the case in previous versions, but it
becomes mandatory in version 12 (and maybe 11 too). Such restriction is not
mentioned in the documentation for version 12 and would be suitable to be.

Best regards

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-07-30 15:41:17 Re: High Availability, Load Balancing, and Replication Feature Matrix
Previous Message Tatsuo Ishii 2020-07-30 07:02:25 Re: High Availability, Load Balancing, and Replication Feature Matrix