Use triggers as a relationship constraint when partitioning will not allow you to create desired foreign keys

[jeremydmiller]

See https://stackoverflow.com/questions/47532269/postgresql-partial-foreign-key.

It's all about partitioning disallowing the usage of foreign keys. You have to revert to triggers instead. Ick.

And folks, this will NOT be a high priority.