Skip site navigation (1) Skip section navigation (2)

Re: BUG #6416: Expression index not used with UNION ALL queries

From: Matteo Beccati <php(at)beccati(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6416: Expression index not used with UNION ALL queries
Date: 2012-01-30 09:52:44
Message-ID: 4F26686C.2090706@beccati.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 29/01/2012 22:33, Tom Lane wrote:
> Matteo Beccati <php(at)beccati(dot)com> writes:
>>> I've just noticed that an expression index I've created was not used with a
>>> view contiaining a UNION ALL. Switching to UNION or querying the table
>>> directly works as expected.
> 
> Looks like I broke this back in November :-(.  Fixed, thanks for the
> report.

Thanks a lot Tom!


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2012-01-30 21:13:56
Subject: Re: BUG #6200: standby bad memory allocations on SELECT
Previous:From: Dave PageDate: 2012-01-30 07:56:55
Subject: Re: Windows x86-64 One-Click Install (9.1.2-1, 9.0.6-1) hangs on "initialising the database cluster" (with work-around)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group