Re: Odd query result

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maximilian Tyrtania <lists(at)contactking(dot)de>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Odd query result
Date: 2012-08-27 14:18:07
Message-ID: 14024.1346077087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Maximilian Tyrtania <lists(at)contactking(dot)de> writes:
>> 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 thatDropping and recreating it fixed it.

Hm, had you changed the behavior of that function since creating the
index?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-08-27 14:20:25 Re: unexpected pageaddr in the log of a standby server
Previous Message Viacheslav N Tararin 2012-08-27 12:17:22 unexpected pageaddr in the log of a standby server