From: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: tsearch2 problem rank_cd() (possibly) crashing postgres |
Date: | 2006-12-08 17:25:50 |
Message-ID: | a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 12/8/06, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:
> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
>
> > On 12/8/06, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> 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.
>
Sir,
even with a seperate schema contrib one cannot drop the stuff
in contrib and reload the new version . Becoz DROPs have to be
cascaded to dependencies which contain real data. Eg
index and table columns that depend on existence of TYPE.
Regds
Mallah.
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Hernandez | 2006-12-08 17:35:20 | unsubscribe |
Previous Message | Scott Marlowe | 2006-12-08 16:33:04 | Re: Should clients warn in case of server version mismatch |