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 по дате отправления