Re: BUG #3767: tsearch2 index creation fatal crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas H(dot)" <me(at)alternize(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: BUG #3767: tsearch2 index creation fatal crash
Date: 2007-11-21 04:53:12
Message-ID: 23539.1195620792@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

"Thomas H." <me(at)alternize(dot)com> writes:
> i saw my mistake. i misinterpreted the examples to show the possibility
> to convert *any* text by using casting to tsvector as an alternative to
> using to_tsvector :)

Yeah, the examples in section 12.1.2 are not actually good practice:
both sides of the match should usually get normalized before comparison,
and these examples don't do that.

I'm not sure that putting in to_tsvector calls there would be an
improvement, though, since at that point we haven't introduced
to_tsvector.

Thoughts anyone?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-11-21 04:58:51 Re: BUG #3767: tsearch2 index creation fatal crash
Previous Message Thomas H. 2007-11-21 04:42:36 Re: BUG #3767: tsearch2 index creation fatal crash

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2007-11-21 04:58:51 Re: BUG #3767: tsearch2 index creation fatal crash
Previous Message Thomas H. 2007-11-21 04:42:36 Re: BUG #3767: tsearch2 index creation fatal crash