If we create a master table and children with classic partitioning: check constraint on children, trigger to insert data into master to dispatch on children etc.
Is it possible to create another table and create some foreign keys directly on master and/or a specific child?
How to manage if not?
I found your question cause I had realized that my declared foreign keys on my master table are not working.
After doing some research to this topic I think this isn't possible on master table using PostgreSQL 9.6. So you must declare the foreign keys at each single partition to let them work - this should work