Re: Odd query result

From: Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com>
To: Maximilian Tyrtania <lists(at)contactking(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Odd query result
Date: 2012-08-27 10:14:17
Message-ID: CAL_0b1um2YtzL7=4CA-srXq4cgusKOCMT6EAT_UaLhttgL5UjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 27, 2012 at 1:56 PM, Maximilian Tyrtania
<lists(at)contactking(dot)de> wrote:
>> 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.

Note that having such functional index you are risking to face similar
oddities again after you modify the function. You need to manually
reindex all the indexes that uses the function after it has been
modified.

To PG hackers. Are there any plans to add dependencies that will
resolve such issues somehow?

--
Sergey Konoplev

a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-consulting.com

Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Georges Racinet 2012-08-27 10:37:54 Re: Odd query result
Previous Message Maximilian Tyrtania 2012-08-27 09:56:46 Re: Odd query result