From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Nagaraj Raj <nagaraj.sf@yahoo.com>
Cc: Pg Bugs <pgsql-bugs@postgresql.org>
Subject: Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition
Date: Tue, 29 Sep 2020 18:22:29 -0400
Message-ID: <724329.1601418149@sss.pgh.pa.us> (raw)
In-Reply-To: <CAApHDvrGCKVEQeJ0Tchxkq86NXvF=HzVoROv_jGAGYv61P8Tuw@mail.gmail.com>
References: <64062533.78364.1601415362244.ref@mail.yahoo.com>
<64062533.78364.1601415362244@mail.yahoo.com>
<CAApHDvrGCKVEQeJ0Tchxkq86NXvF=HzVoROv_jGAGYv61P8Tuw@mail.gmail.com>
David Rowley <dgrowleyml@gmail.com> writes:
> On Wed, 30 Sep 2020 at 10:36, Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
>> Is it mandatory/necessary that the `partition column` should be a primary key? cause if I include `load_dttm` as `PK` then its working fine.
> Yes, this is required.
Indeed. However, this complaint shows that the error message is not clear
enough. I propose changing it to
ERROR: unique constraint on partitioned table must be a superset of the partitioning columns
or perhaps
ERROR: unique constraint on partitioned table must include all partitioning columns
The DETAIL seems fine as-is:
DETAIL: PRIMARY KEY constraint on table "l_billing_account_p" lacks column "load_dttm" which is part of the partition key.
> There's mention in [1] section 5.10.2.3. "Unique constraints on
> partitioned tables must include all the partition key columns. This
> limitation exists because PostgreSQL can only enforce uniqueness in
> each partition individually.". That text likely should also mention
> PRIMARY KEY constraints. That probably should be changed
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.
regards, tom lane
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-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, dgrowleyml@gmail.com, alvherre@2ndquadrant.com, nagaraj.sf@yahoo.com
Subject: Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition
In-Reply-To: <724329.1601418149@sss.pgh.pa.us>
* 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