constraint name change while pg_pathman upgrade from 1.3 to 1.4
luowencai opened this issue · 1 comments
luowencai commented
Problem description
Explain your problem here (it's always better to provide reproduction steps) ...
When pg_pathman was 1.3, the constraint name was pathman_tablename_p20220218_3_check, while upgrade to 1.4, the constraint name is pathman_table_p20220218_check.
While select reult, come in follow error...
select count(1) from tablenamer where recdate = '2022-02-10';
ERROR: constraint "pathman_tablename_p20220131_check" of partition "tablename_p20220131" does not exist
Environment
select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
luowencai commented
Problem solve by upgrade postgresql to 13.5 and migrate pg_pathman to postgresql orgin paritition.