RE: [Mailmanager-users] Text search not working, MM 2.0.5 -w- PostgreSQL 8.0.6 on Slackware 10.1

[Samuel J S. <sst...@dp...>]

Kevin,

When I go to create the database with the setupdb.py script, I it prints out
the following.  The part that has me concerned is that it says 'type
"tsquery" is not yet defined'  Any suggestions on what this might be?  I
believe I have all the permissions set correctly.  I figure this is where
the text searching is failing... not sure why.

zope@jobe:/usr/local/zope/mailManager/Products/MailManager$
./scripts/setupdb.py \
> -p itNoRush \        
> -a /usr/share/postgresql/contrib/tsearch2.sql \
> mailmanager
Warning - MySQL support is not available
psql:/usr/share/postgresql/contrib/tsearch2.sql:13: NOTICE:  CREATE TABLE /
PRIMARY KEY will create implicit index "pg_ts_dict_pkey" for table
"pg_ts_dict"
psql:/usr/share/postgresql/contrib/tsearch2.sql:145: NOTICE:  CREATE TABLE /
PRIMARY KEY will create implicit index "pg_ts_parser_pkey" for table
"pg_ts_parser"
psql:/usr/share/postgresql/contrib/tsearch2.sql:244: NOTICE:  CREATE TABLE /
PRIMARY KEY will create implicit index "pg_ts_cfg_pkey" for table
"pg_ts_cfg"
psql:/usr/share/postgresql/contrib/tsearch2.sql:251: NOTICE:  CREATE TABLE /
PRIMARY KEY will create implicit index "pg_ts_cfgmap_pkey" for table
"pg_ts_cfgmap"
psql:/usr/share/postgresql/contrib/tsearch2.sql:337: NOTICE:  type
"tsvector" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/postgresql/contrib/tsearch2.sql:342: NOTICE:  argument type
tsvector is only a shell
psql:/usr/share/postgresql/contrib/tsearch2.sql:396: NOTICE:  type "tsquery"
is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/postgresql/contrib/tsearch2.sql:401: NOTICE:  argument type
tsquery is only a shell
psql:/usr/share/postgresql/contrib/tsearch2.sql:543: NOTICE:  type
"gtsvector" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/postgresql/contrib/tsearch2.sql:548: NOTICE:  argument type
gtsvector is only a shell

Database has been configured 

Thanks again,
Sam
 
Samuel J Stanaitis, Network Administrator
Decorative Product Source, Inc.