On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
On 12/8/06, Oleg Bartunov <oleg@xxxxxxxxxx> wrote:
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
> Dear
> Oleg,
> In local development server. the old functions still exists in
> postgresql catalogs. But probably they are missing in the
> newer version of tsearch2.so that came with 8.2.0 . And hence
> postgres is crashing. I feel this should have been informed in the
> release notes.
yes, you're right. Someone has offered help to write this but then
silently dissapeared, so we stay without release notes. Could you
summarise your experience and write them and we add them for 8.2.1
Sir,
Dont you feel the incremental features should be available as upgrade
patches. eg at one point of time i found that the = ( ts_vector ,
ts_vector)
operator is missing in my database. later i had to manually create
the operator by looking at the tsearch2.sql file of later releases.
this is becuse tsearch2.sql (i think) was not runnable on database
having older versions of tsearch2.
yes i would summarise my experience but lemme know if the above
is an issue.
some people use separate scheme contrib to load all contrib stuff,
so upgrading is much easy.
also do i need to change my application code ?
(becoz the older function is not available)
from my understanding, the only function missed is the
-CREATE FUNCTION rank_cd(int4, tsvector, tsquery)
-CREATE FUNCTION rank_cd(int4, tsvector, tsquery, int4)
you need to change your application to use rank_cd()
as it described in reference manual.
-CREATE FUNCTION snb_ru_init(internal)
changed to
+CREATE FUNCTION snb_ru_init_koi8(internal)
+CREATE FUNCTION snb_ru_init_utf8(internal)
since we now support multibyte encoding (UTF-8 as well)
Warm Regds
Mallah.
Oleg
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
