Re: Regarding use of single column as primary key on partitioned table

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Regarding use of single column as primary key on partitioned table
Дата
Msg-id 9841DB8A-C3D7-42F4-9AE1-83076CAB1576@thebuild.com
обсуждение исходный текст
Ответ на Regarding use of single column as primary key on partitioned table  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Список pgsql-general

> On Sep 27, 2024, at 21:25, Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
>
> Can't we use primary key on singal column(betid) on partitioned table rather than using composite key
(placedon,betid)?

No.  Any unique constraint on a partitioned table must include the partition key, including a primary key constraint.


В списке pgsql-general по дате отправления: