Re: Odd query result - Mailing list pgsql-general

From Tom Lane
Subject Re: Odd query result
Date
Msg-id 14024.1346077087@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd query result  (Maximilian Tyrtania <lists@contactking.de>)
Responses Re: Odd query result  (Maximilian Tyrtania <maximilian.tyrtania@contactking.de>)
List pgsql-general
Maximilian Tyrtania <lists@contactking.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 that�Dropping and recreating it fixed it.

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

            regards, tom lane


pgsql-general by date:

Previous
From: Viacheslav N Tararin
Date:
Subject: unexpected pageaddr in the log of a standby server
Next
From: Adrian Klaver
Date:
Subject: Re: unexpected pageaddr in the log of a standby server