Re: query plan ignoring check constraints

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)surnet(dot)cl>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: query plan ignoring check constraints
Date: 2005-06-21 12:26:31
Message-ID: 20050621122631.GE28910@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 21, 2005 at 22:11:25 +1000,
John Hansen <john(at)geeknet(dot)com(dot)au> wrote:
>
> I misunderstood the original post as a request for queries NOT to use
> indexes where it doesn't match the table contents.

I think that is what they were asking, but I don't think they wanted
to see a sequential scan as the alternative.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2005-06-21 12:37:47 Re: Schedule for 8.1 feature freeze
Previous Message John Hansen 2005-06-21 12:11:25 Re: query plan ignoring check constraints