Re: tsearch2 and unexpected exists (Function defn)

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 (Function defn)
Date: 2003-09-07 18:04:43
Message-ID: Pine.LNX.4.21.0309071857230.1911-200000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sun, 7 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...

> ... shouldn't that PG_FREE_IF_COPY be
> PG_FREE_IF_COPY(name,0), note the 0 instead of 1?

My rather quick and simple testing, i.e. trying the query that was breaking
for me, now works with that change.

I've no idea how or if you're doing patches to the distribution for use with
7.3 series servers, but this looks sensible to me so I've attached a patch.

And sorry for adding to your email load recently.

--
Nigel Andrews

Attachment Content-Type Size
query.c.patch text/plain 368 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ohp 2003-09-07 18:22:30 Unixware 713 probs
Previous Message Nigel J. Andrews 2003-09-07 17:50:45 Re: tsearch2 and unexpected exists (Function defn)