Re: full text search in 8.3 - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: full text search in 8.3
Date
Msg-id Pine.LNX.4.64.0710111819300.23412@sn.sai.msu.ru
Whole thread Raw
In response to Re: full text search in 8.3  (andy <andy@squeakycode.net>)
List pgsql-hackers
On Thu, 11 Oct 2007, andy wrote:

> Oleg Bartunov wrote:
>> Andy,
>> 
>> seems you're a right person for writing migration guide.
>> 
>> Oleg
>> On Wed, 10 Oct 2007, andy wrote:
>> 
>
> Where would be an easy place to find all the renamed functions?

My incomplete list:
http://www.sai.msu.su/~megera/wiki/Tsearch2_83_changes

psql \h shows syntax of text search commands

\h create text search
\h alter text search
\h drop text search

>
> My experience with fts is limited to one project, and I just used all the 
> default dictionaries, so I've never even played with any of that.
>
> That being said, I'd be happy to write up what I can (and I can try to put 
> together a list of the renamed functions).
>
> Is there any chance there is an easier way to backup/restore?  On one hand, 
> its not too bad, and it'll only be once (correct?).  Now that fts is in core 
> future backup/restores will work, right?  I think it's analogous to telling 
> someone they are updating from tsearch2 to tsearch3, and it might be a little 
> more painful than just a backup/restore.
>
> On the other hand I think a backup/restore will pollute the new db with a 
> bunch of functions and types that wont ever be used, so it's so much cleaner 
> to build it by hand.
>
> Are there other fts users that might have opinions on that?
>
> -Andy
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>      choose an index scan if your joining column's datatypes do not
>      match
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plan invalidation vs temp sequences
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: full text search in 8.3