[Bizgres-general] constraint exclusion (table partitioning) not working?

[Josh Berkus]

Bob,

> While it is unfortunate that the type inference needs a little help
> in this case, the workaround is quite reasonable and isn't going to
> be a problem at all for us.  I can confirm that rewriting the CHECK
> constraints to include explicit type information does indeed allow CE
> to take place.

Great, because according to Tom it is in fact a very difficult fix.   He's 
thinking of ways to fix it for 8.2, which will require extra information 
in pg_opclass.

-- 
Josh Berkus                GreenPlum Inc
Community Liason       www.greenplum.com
415-752-2500       jberkus at greenplum.com