cache lookup failed for constraint when alter table referred bypartition table - Mailing list pgsql-hackers

From Rajkumar Raghuwanshi
Subject cache lookup failed for constraint when alter table referred bypartition table
Date
Msg-id CAKcux6nWS_m+s=1Udk_U9B+QY7pA-Ac58qR5BdUfOyrwnWHDew@mail.gmail.com
Whole thread Raw
Responses Re: cache lookup failed for constraint when alter table referred bypartition table  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Hi,

I am getting cache lookup failed for constraint error on master and 11beta3 with below test case.

[edb@localhost bin]$ ./psql postgres
psql (11beta3)
Type "help" for help.

postgres=# CREATE TABLE non_part (a INT,PRIMARY KEY(a));
CREATE TABLE
postgres=# CREATE TABLE part (a INT REFERENCES non_part(a)) PARTITION BY RANGE(a);
CREATE TABLE
postgres=# CREATE TABLE part_p1 PARTITION OF part FOR VALUES FROM (MINVALUE) TO (MAXVALUE);
CREATE TABLE
postgres=# ALTER TABLE non_part ALTER COLUMN a TYPE bigint;
ERROR:  cache lookup failed for constraint 16398

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

pgsql-hackers by date:

Previous
From: Christoph Berg
Date:
Subject: Re: Collation versioning
Next
From: Peter Moser
Date:
Subject: Re: [HACKERS] [PROPOSAL] Temporal query processing with range types