Re: bug of pg_trgm?
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Fujii Masao <masao.fujii@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-09-06T21:24:24Z
Lists: pgsql-hackers
On 09/06/2012 05:09 PM, Tom Lane wrote: > 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. > > OK, Thanks. cheers andrew