Thanks a lot Michael. Get well soon.
From: Michael Lewis
Sent: November-18-19 12:57 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: ERROR: there is no unique constraint matching given keys for
referenced table "audit_p"
On Mon, Nov 18, 2019 at 10:10 AM Shatamjeev Dewan
Hi Michael,
I am trying to create a foreign key constraint on a table : audit_param in
postgres 12 which references partitioned table audit_p. is there anyway to get
rid of this error.
ERROR: there is no unique constraint matching given keys for referenced table
"audit_p"
Thanks a ton Michael
From: Michael Lewis
Sent: November-01-19 3:20 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: Declarative Range Partitioning Postgres 11
On Fri, Nov 1, 2019 at 9:22 AM Shatamjeev Dewan
mailto:sde...@nbsps.com>> wrote:
Hi Michael,
I want to create a partit
Hi Michael,
I want to create a partition by year and subpartition by month in postgres 11
timestamp column. Please advise syntax.
Thanks,
Shatamjeev
From: Michael Lewis
Sent: October-08-19 1:33 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: Declarative Range Partitioning Postgres 11
Thanks a lot Michael for invaluable advise . Appreciate your great help and
support.
From: Michael Lewis
Sent: October-08-19 1:33 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: Declarative Range Partitioning Postgres 11
On Tue, Oct 8, 2019 at 8:00 AM Shatamjeev Dewan
mailto:sde
.
Thanks,
Shatamjeev
From: Michael Lewis
Sent: October-07-19 7:18 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: Declarative Range Partitioning Postgres 11
No, what you want is not possible and probably won't ever be I would expect.
Scanning every partition to validate the primar
Thanks Michael.
From: Michael Lewis
Sent: October-07-19 7:18 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: Declarative Range Partitioning Postgres 11
No, what you want is not possible and probably won't ever be I would expect.
Scanning every partition to validate the primar
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
