Postgres Pro
Downloads
Home   >   mailing lists

Partitioning Column needs to be Key - Mailing list pgsql-bugs

From Vaishakha Madhava
Subject Partitioning Column needs to be Key
Date
Msg-id CALguuV-KCX1yJJn_BmKuwLc+YzU+sR3puSFjyn7b4K-TMyV_Cg@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning Column needs to be Key  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-bugs
Tree view
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". 

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: ERROR: subtransaction logged without previous top-level txn record
Next
From: PG Bug reporting form
Date:
Subject: BUG #16266: Server crash on SELECT event_trigger-returning function