So, for upgrading tsearch to V2 you need to do following:
1 rename columns or typecast for type txtidx to tsvector, query_txt to tsquery
2 rename function txt2txtidx to to_tsvector, ( may be to strip(to_tsvector()),
now tsvector has information for ranking ), trigger 'tsearch' isn't changed
3 operator class (in create index command) gist_txtidx_ops to gist_tsvector_ops
4 In queries: operator ## to @@ to_tsquery() and remove mquery_txt typecast
5 If your locale of pgsql differ from 'C', execute before first query
select set_curcfg('default');That's all. So upgrade from v1 to v2 isn't difficult.
Christopher Kings-Lynne wrote:
Out of interest - is it completely backwards compatible?
unfortunately, no
Then surely fully replacing tsearch will cause badness?
I see, so are you suggesting separate dir for tsearch v2 ?
Well, we use tserach 1 extensively. I want to be able to upgrade to 7.4 and have nothing break!
If things will break, then you need to have a tsearch2 dir instead.
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-- Teodor Sigaev E-mail: [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
