Re: BUG #5183: Wrong select results using multicolumn gin indexes

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Yury Don <yura(at)vpcit(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5183: Wrong select results using multicolumn gin indexes
Date: 2009-11-13 11:18:32
Message-ID: 4AFD4088.9020004@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you, fixed.

> We are using btree_gin module. I've created multicolumn gin indexes on table
> with one column type tsvector and other column type integer. After index
> creation selects works well. But after inserting new rows inserted row
> appears in selects even when it does not satisfy conditions. The same
> results with one column type int[] and other column type text or integer.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Oleg Serov 2009-11-13 11:25:14 Crazy query plan.
Previous Message Heikki Linnakangas 2009-11-13 10:41:33 Re: BUG #5185: postgres error "invalid page header in block xx of relation "pg_proc_proname_args_nsp_index"