Tatsuo Ishii <ishii@postgresql.org> wrote:
> http://sylpheed.sraoss.jp/tmp/searcherdb84.tar.bz2
Using that on my kubuntu machine with no configure options except
prefix:
hiro@kgrittn-desktop:~$ /usr/local/pgsql-8.4beta2/bin/psql -U hiro
sylph
psql (8.4beta2)
Type "help" for help.
sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date,
folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (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: -26
sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date,
folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (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: -26
sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date,
folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid)
WHERE plainto_tsquery(E'tsearch') @@ body_index;
ERROR: tuple offset out of range: 609
sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date,
folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid)
WHERE plainto_tsquery(E'tsearch') @@ body_index;
ERROR: tuple offset out of range: 609
Given that I can replicate this, is there some useful next step?
-Kevin