On Thu, 11 Oct 2007, andy wrote:

Oleg Bartunov wrote:

seems you're a right person for writing migration guide.

On Wed, 10 Oct 2007, andy wrote:

Where would be an easy place to find all the renamed functions?

My incomplete list:

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?


---------------------------(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

Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to