pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: pgsql-admin@postgresql.org
Subject: Re: tsearch2 problem rank_cd() (possibly) crashing postgres
Date: Fri, 8 Dec 2006 22:55:50 +0530
Message-ID: <a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0612081901050.16338@sn.sai.msu.ru>
References: <a97c77030612080504t44a2a14ved27d397ad59453@mail.gmail.com>
	<Pine.LNX.4.64.0612081755170.16338@sn.sai.msu.ru>
	<a97c77030612080755p45f9be97lebcec3335be1c8e3@mail.gmail.com>
	<Pine.LNX.4.64.0612081901050.16338@sn.sai.msu.ru>

On 12/8/06, Oleg Bartunov <oleg@sai.msu.su> wrote:
> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
>
> > On 12/8/06, Oleg Bartunov <oleg@sai.msu.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.



view thread (15+ messages)

Message-ID: <a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com>
Permalink:  ../a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mallah.rajesh@gmail.com, oleg@sai.msu.su
  Subject: Re: tsearch2 problem rank_cd() (possibly) crashing postgres
  In-Reply-To: <a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com>
  References: <a97c77030612080504t44a2a14ved27d397ad59453@mail.gmail.com> <Pine.LNX.4.64.0612081755170.16338@sn.sai.msu.ru> <a97c77030612080755p45f9be97lebcec3335be1c8e3@mail.gmail.com> <Pine.LNX.4.64.0612081901050.16338@sn.sai.msu.ru> <a97c77030612080925p44443875s621f13ea1e7ac2ea@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox