Table inheritance: Enforcing unique constraints ac

2019-08-01 03:34发布

问题:

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?

回答1:

No, this is not currently possible. The best you can do is to create a trigger that does the verification manually.