How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL

I'm drawn to this but it has several foot guns like INSERTs will fail for late arriving data if the constraints have been updated etc