Re: Table Partitioning

On Thu, Jul 30, 2020 at 01:33:29PM +0000, PG Doc comments form wrote:
> 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.

Can you give us a reproducible test case?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee