Hi,
I'm testing a new RT4 installation with Postgres to try FullText search. I got
RT up and running, ran the rt-setup-fulltext-index utility, updated my
RT_SiteConfig file but get errors when trying to run the indexer:
root@rt2:/opt/rt4# sbin/rt-setup-fulltext-index --dba postgres --dba-password
'<removed>'
Enter name of a DB table that will be used to store Pg tsvector. Attachments
table can be used.
[Attachments]:
Enter name of a column that will be used to store Pg tsvector
[ContentIndex]:
Configure your RT via site config:
Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => 'ContentIndex',
Table => 'Attachments',
);
Going to do the following change in the DB:
ALTER TABLE Attachments ADD COLUMN ContentIndex tsvectorYou have choice between
GiST or GIN index, the first is times slower to search, but it takes less place
and faster to update.
[GiST]:
Going to do the following change in the DB:
CREATE INDEX ContentIndex_idx ON Attachments USING gist(ContentIndex)
root@rt2:/opt/rt4#
root@rt2:/opt/rt4# sbin/rt-fulltext-indexer
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value $table in
concatenation (.) or string at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm line 1223.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm:1223)
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value
$args{"TABLE2"} in concatenation (.) or string at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 989.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:989)
[Fri May 20 19:40:14 2011] [warning]: DBD::Pg::st execute failed: ERROR:
relation "_3" does not exist
LINE 1: ...) AND ( Transactions_1.ObjectId = main.id ) JOIN _3 ON ( _...
^ at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:509)
<snip>
Did I miss something? I read through the RT_Config file comments and the --help
flag for all related binaries.
Thanks,
Patrick
