Declarative Range Partitioning Postgres 11

Поиск
Список
Период
Сортировка
Искать
От
Shatamjeev Dewan
Тема
Declarative Range Partitioning Postgres 11
Дата
Msg-id
F2F23E564EB92A4C80228EB86713BA130BD969@TO1RODC.nbspaymentsolutions.com
Список
Дерево обсуждения
Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>
Re: Declarative Range Partitioning Postgres 11 Michael Lewis <mlewis@entrata.com>
Re: Declarative Range Partitioning Postgres 11 Ron <ronljohnsonjr@gmail.com>
Re: Declarative Range Partitioning Postgres 11 Michael Lewis <mlewis@entrata.com>
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>
Re: Declarative Range Partitioning Postgres 11 Michael Lewis <mlewis@entrata.com>
Re: Declarative Range Partitioning Postgres 11 Ron <ronljohnsonjr@gmail.com>
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>
Re: Declarative Range Partitioning Postgres 11 Michael Lewis <mlewis@entrata.com>
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan <sdewan@nbsps.com>

Hi,

 

I am trying to create a table in postgres 11 with timestamp column as  a partition key using  PARTITION BY RANGE (create_dtt). The table definition has also an id column which is a primary key.

 

ERROR:  insufficient columns in PRIMARY KEY constraint definition

DETAIL:  PRIMARY KEY constraint on table "audit_p" lacks column "create_dtt" which is part of the partition key.

 

I don’t want partition key column   : create_dtt  to part of composite primary key.  Is there any way I can create range partition on date column without including as part of primary key .

 

Please advise.

 

Thanks,

Shatamjeev

 

В списке pgsql-general по дате отправления
От: Ravi Krishna
Дата:
Сообщение: PG 12 not yet for mac
От: Tomas Vondra
Дата:
Сообщение: Re: PG 12 not yet for mac
FAQ