Re: Odd query result - Mailing list pgsql-general

From Maximilian Tyrtania
Subject Re: Odd query result
Date
Msg-id 72CCC486-8E30-4695-9A3A-7263993B15E5@contactking.de
Whole thread Raw
In response to Re: Odd query result  (Sergey Konoplev <gray.ru@gmail.com>)
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.*));

Dropping and recreating it fixed it.

Thanks a lot,

Maximilian Tyrtania
http://www.contactking.de

pgsql-general by date:

Previous
From: Georges Racinet
Date:
Subject: Re: Odd query result
Next
From: Viacheslav N Tararin
Date:
Subject: unexpected pageaddr in the log of a standby server