Re: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table - Mailing list pgsql-bugs

I wrote:
> "Eric Thompson" <eric.thompson@salliemae.com> writes:
>> test=# -- remove any irrelevant constraint from the master table, and now
>> the date partitioning works

> Hmm.  Tracing through this, it seems your child tables have exactly 101
> separate constraint clauses; removing one from the parent table gets it
> down to 100.  Which is where the cutoff installed by this patch is:

> http://archives.postgresql.org/pgsql-committers/2008-11/msg00146.php

I've partially reverted that patch:

http://archives.postgresql.org/pgsql-committers/2009-05/msg00202.php

so the next 8.3.x release should behave as you're expecting.

            regards, tom lane