Re: Regarding use of single column as primary key on partitioned table
| От | Ron Johnson |
|---|---|
| Тема | Re: Regarding use of single column as primary key on partitioned table |
| Дата | |
| Msg-id | CANzqJaAknAV3vhxQ3tnJkGbHEmQJwWhi5jVW7wYkwZx4WQh2DA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Regarding use of single column as primary key on partitioned table ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Regarding use of single column as primary key on partitioned table
|
| Список | pgsql-general |
On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, September 27, 2024, Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
ERROR: unique constraint on partitioned table must include all partitioning columns
DETAIL: PRIMARY KEY constraint on table "bet" lacks column "placedon" which is part of the partition key.
test=>Can't we use primary key on singal column(betid) on partitioned table rather than using composite key (placedon,betid)?No. It would be misleading to allow such a thing because a unique index can only span a single partition.
That is IMO a serious (and probably unfixable, given how PG stores tables) flaw in PG's partitioning design.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!
В списке pgsql-general по дате отправления: