Postgres Pro
Downloads
Home   >   mailing lists

Problem with Constraint Exclusion ON - Mailing list pgsql-general

From Ashish Karalkar
Subject Problem with Constraint Exclusion ON
Date
Msg-id 4C626290.5000605@netcore.co.in
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Problem with dumps
Next
From: "Daniel Verite"
Date:
Subject: Re: MySQL versus Postgres