Re: tsearch2 and unexpected exists

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2 and unexpected exists
Date: 2003-09-06 00:09:51
Message-ID: Pine.LNX.4.21.0309060106110.1911-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 6 Sep 2003, Nigel J. Andrews wrote:

> On Thu, 4 Sep 2003, Teodor Sigaev wrote:
>
> >
> >
> > Nigel J. Andrews wrote:
> > >
> > > This will be a little vague, it was last night and I can't now do the test in
> > > that db (see below) so can't give the exact wording.
> > >
> > > I seem to remember a report a little while ago about tsearch v2 causing
> > > unexpected backend exit messages with 7.3.4 and now I'm getting similar
> > > messages unpredictably and I can't find the thread in the archives either.
> > > ...
> >
> > Have you a core file, if yes then send gdb output, pls...
>
>
>
> Unfortunately it was only after getting this core file that I noticed I don't
> have it built with debugging symbols. However, as a starting point, here's the
> psql session that kicks the core dump, the entire log for the server (although
> ...

Oh, one snippet I forgot to mention. I changed the permissions for the
installed tsearch bits by allowing public usage on the schema and select on the
4 tsearch2 tables contained in it. Could this be significant?

--
Nigel J. Andrews

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Relaxin 2003-09-06 00:54:47 Re: Optimizer picks an ineffient plan
Previous Message Nigel J. Andrews 2003-09-06 00:03:34 Re: tsearch2 and unexpected exists