postgrespro/pg_pathman

constraint name change while pg_pathman upgrade from 1.3 to 1.4

luowencai opened this issue · 1 comments

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

Problem solve by upgrade postgresql to 13.5 and migrate pg_pathman to postgresql orgin paritition.