Discussion on question: Postgres fails to propagate constraint into subquery

But if you do, please post a self containing example, with full CREATE TABLE, CREATE VIEW and the whole query, not just a sketch.

Now that I think about it, it might be worth if you sent an email response to that thread, providing an example of your query (that gets the "wrong"/slow plan).

postgresql.org/message-id/flat/…