cache lookup failed for constraint when alter table referred bypartition table

Поиск
Список
Период
Сортировка
От Rajkumar Raghuwanshi
Тема cache lookup failed for constraint when alter table referred bypartition table
Дата
Msg-id CAKcux6nWS_m+s=1Udk_U9B+QY7pA-Ac58qR5BdUfOyrwnWHDew@mail.gmail.com
обсуждение исходный текст
Ответы Re: cache lookup failed for constraint when alter table referred bypartition table
Список 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 по дате отправления: