Problem with Constraint Exclusion ON

From: Ashish Karalkar <ashish(dot)karalkar(at)netcore(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with Constraint Exclusion ON
Date: 2010-08-11 08:42:56
Message-ID: 4C626290.5000605@netcore.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2010-08-11 09:03:54 Re: MySQL versus Postgres
Previous Message Guillaume Lelarge 2010-08-11 07:55:05 Re: Problem with dumps