Horton
Menu

Re: bug of pg_trgm?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Fujii Masao <masao.fujii@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-09-06T21:09:48Z
Lists: 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