Re: Odd query result

From: Maximilian Tyrtania <lists(at)contactking(dot)de>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Odd query result
Date: 2012-08-27 09:56:46
Message-ID: C75BB35F-05B1-4386-885C-CED0C9D56DD0@contactking.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania
> <lists(at)contactking(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2012-08-27 10:14:17 Re: Odd query result
Previous Message Maximilian Tyrtania 2012-08-27 09:53:17 Re: Odd query result