Jin Kim
Reputation: 17732
Table inheritance: Enforcing unique constraints across partitions?
I have a table that I would like to partition, but I don't know how to deal with the uniqueness constraints.
Is it possible to create a unique constraint across multiple child tables?
Upvotes: 6
Views: 3461
Answers (1)
Magnus Hagander
Reputation: 25108
No, this is not currently possible. The best you can do is to create a trigger that does the verification manually.
Upvotes: 8
Related Questions
- Self-managing PostgreSQL partition tables
- Unique constraints name on partitioned tables
- Postgres Inheritance based partition scanning all the partitions
- Use of Postgres table inheritance
- Unique Index over postgresql partitions
- How to add or emulate a unicity constraint on a column part of a composite primarey key of a partitioned table in postgres 12?
- Primary key and constraints on partitioned tables
- Using partition and Inherits in one table
- Is it safe to use postgres table partitioning with overlapping constraints?
- Postgres ignores table constraints, scans all inherited tables even if constraints don't match