Re: bug of pg_trgm? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: bug of pg_trgm?
Date
Msg-id 3441.1346965788@sss.pgh.pa.us
Whole thread Raw
In response to Re: bug of pg_trgm?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: bug of pg_trgm?
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 08/20/2012 01:26 PM, Tom Lane wrote:
>> Fujii Masao <masao.fujii@gmail.com> writes:
>>> OK. Attached patch fixes the problem as you suggested, i.e., it backs up
>>> "endword" if the second loop exits in an escape pair.

>> Applied with a bit of further adjustment of the comments.  Thanks!

> When moving to a release with this change, will users need to reindex 
> trgm indexes?

No.  This only changes extraction of search trigrams from a LIKE pattern,
not extraction of trigrams from text to be indexed.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Reduce the time to know trigger_file's existence
Next
From: Andrew Dunstan
Date:
Subject: Re: bug of pg_trgm?