Re: full text search in 8.3

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83