Re: How to submit Tsearch V2 ?

I think with upgrade X.Y to X.Y+1 version of pgsql you need dump/restore all 
databases, isn't it?

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 majordomo@postgresql.org)

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru