Re: Odd query result - Mailing list pgsql-general

From Maximilian Tyrtania
Subject Re: Odd query result
Date
Msg-id C75BB35F-05B1-4386-885C-CED0C9D56DD0@contactking.de
Whole thread Raw
In response to Re: Odd query result  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Odd query result  (Sergey Konoplev <sergey.konoplev@postgresql-consulting.com>)
Re: Odd query result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania
> <lists@contactking.de> wrote:
>> What might be up there?
>
> It might be a broken index issue. Please show the EXPLAIN for these queries.

It was. I had an index like this:

CREATE INDEX idx_firmen_iskunde_index
 ON firmen
 USING btree
 (f_firmen_iskunde(firmen.*));

Sorry, should have mentioned that…Dropping and recreating it fixed it.

Thanks a lot,

Maximilian Tyrtania
http://www.contactking.de


pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Odd query result
Next
From: Sergey Konoplev
Date:
Subject: Re: Odd query result