Horton

Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Nagaraj Raj <nagaraj.sf@yahoo.com>, Pg Bugs <pgsql-bugs@postgresql.org>
Date: 2020-09-29T22:43:38Z
Lists: pgsql-bugs 
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> On 2020-Sep-29, Tom Lane wrote:
>> Meh.  If you've read that bit you probably already understand that
>> pkeys are unique constraints.  I think the problem is with the error
>> text not the docs.

> Maybe mention PKs in parens:

> "Unique constraints (and[, by extension,] primary key constraints) on
> partitioned tables must include all the partition key columns. This
> limitation exists because PostgreSQL can only enforce uniqueness in each
> partition individually.".

I don't object to clarifying that (and that wording seems fine), but I
think fixing the error message is more important.  We'd not be having this
discussion if the OP had found that documentation.

			regards, tom lane

Commits

  1. Reword partitioning error message

  2. Doc: Improve clarity on partitioned table limitations