Re: Planner not using UNIQUEness of index properly

From: John Burger <john(at)mitre(dot)org>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Planner not using UNIQUEness of index properly
Date: 2007-12-10 16:22:37
Message-ID: 1A810F50-1B24-4623-A708-AB79A0EAA668@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>> I would think UNIQUE => one row is pretty obvious - what am I
>> missing? (Unless it's that I'm still stuck in 7.4.)
>
> That would be the problem :-( ... a look at the code suggests that the
> ability to do anything intelligent with expression indexes was added
> in 8.0.

Whaa. Okay, more ammunition, thanks.

- John D. Burger
MITRE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-12-10 16:22:59 Re: Simpler dump?
Previous Message Tom Lane 2007-12-10 16:22:18 Re: Simpler dump?