Re: BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alexander Hill <alex(at)hill(dot)net(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd
Date: 2014-02-12 14:31:51
Message-ID: 20140212143151.GA12551@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Feb 12, 2014 at 09:49:32AM +0800, Alexander Hill wrote:
> Hi Bruce,
>
> In normal use this won't affect any data that ends up in an index.
>
> The only exception would be where somebody has created an index over the result
> of ts_rank_cd - indexing search rank for the most common search terms, maybe?

OK, good.

> But that's true of any function whose result is indexed. What's the upgrade
> policy in that case?

Well, we document that the function output changed, and if anyone is
using the function for an index, they need to rebuild the index, so I
think we are fine fixing this for 9.4.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-02-12 15:40:52 Re: BUG #9198: psql -c 'SET; ...' not working
Previous Message Alvaro Herrera 2014-02-12 14:16:07 Re: BUG #9190: Could not fsync file "pg_clog/0000": Bad file descriptor.