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

No foreign key support on template based partitioning #643

Open
Asafb26 opened this issue Mar 25, 2024 · 0 comments
Open

No foreign key support on template based partitioning #643

Asafb26 opened this issue Mar 25, 2024 · 0 comments

Comments

@Asafb26
Copy link

Asafb26 commented Mar 25, 2024

pg_partman has a crucial solution for cases that partition key is not a part of the primary key, provided as a template table to add a PK on sub tables but not on the partition table.
The issue is that now I cannot point to the partition table with a FK constraint, there is no PK on that table and I get an error: ERROR: there is no unique constraint matching given keys for referenced table

See discussion here with reproducible use-case #638

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