Partitioning Column needs to be Key

From: Vaishakha Madhava <vaishakha(dot)madhava(at)314ecorp(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Partitioning Column needs to be Key
Date: 2020-02-19 06:30:36
Message-ID: CALguuV-KCX1yJJn_BmKuwLc+YzU+sR3puSFjyn7b4K-TMyV_Cg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,
When we try to create partitioning table based on a column , If that table
contains a primary key or unique key ,it gives error saying "UNIQUE
constraint on table "ac" lacks column "abc" which is part of the partition
key".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-02-19 08:00:01 BUG #16266: Server crash on SELECT event_trigger-returning function
Previous Message Amit Kapila 2020-02-19 03:56:32 Re: ERROR: subtransaction logged without previous top-level txn record