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: [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