Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

constraint name change while pg_pathman upgrade from 1.3 to 1.4 #246

Closed
luowencai opened this issue Feb 18, 2022 · 1 comment
Closed

constraint name change while pg_pathman upgrade from 1.3 to 1.4 #246

luowencai opened this issue Feb 18, 2022 · 1 comment

Comments

@luowencai
Copy link

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
Copy link
Author

luowencai commented Feb 23, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant