Problem with Constraint Exclusion ON

Started by Ashish Karalkarover 15 years ago1 messagesgeneral
Jump to latest
#1Ashish Karalkar
ashish.karalkar@netcore.co.in

Hello All,

I am facing problem with constraint exclusion in table partitioning.

I have master table and 10 child table's with list partitioning.

constraint exclusion ON works for all the check constraint except for
the "NOT IN " check constraint.

Is this an expected ?

Here is an example:

http://pgsql.privatepaste.com/74d558e05f

Any help would be much /appreciated./

--

With Regards
Ashish Karalkar