Re: 8.4b2 tsearch2 strange error - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4b2 tsearch2 strange error
Date
Msg-id 9436.1244054652@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4b2 tsearch2 strange error  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: 8.4b2 tsearch2 strange error
List pgsql-hackers
Tatsuo Ishii <ishii@postgresql.org> writes:
> STATEMENT:  SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN
msg_folderinfoUSING (msg_sid) WHERE plainto_tsquery(E'a') @@ body_index
 
> NOTICE:  text-search query contains only stop words or doesn't contain lexemes, ignored
> ERROR:  unrecognized operator: -50

I found the cause of this one --- the new code for estimating the
selectivity of @@ was not guarding against the possibility that the
given TSQuery is empty, as it is in this example.

I'm still unable to reproduce the "tuple offset out of range" errors.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] trouble with to_char('L')
Next
From: Gregory Stark
Date:
Subject: Re: Plan time Improvement - 64bit bitmapset