Thread: Tsearch2 install on postgres 8.2 NOTICE messages

Hello list,

I'm trying to install tsearch2 on a freshly created database in 8.2
but I get these NOTICES when doing so.
Is this something to be concerned about?

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_dict_pkey" for table "pg_ts_dict"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_parser_pkey" for table "pg_ts_parser"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_cfg_pkey" for table "pg_ts_cfg"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_cfgmap_pkey" for table "pg_ts_cfgmap"
NOTICE:  type "tsvector" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type tsvector is only a shell
NOTICE:  type "tsquery" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type tsquery is only a shell
NOTICE:  type "gtsvector" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type gtsvector is only a shell
NOTICE:  type "gtsq" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type gtsq is only a shell

psql (PostgreSQL) 8.2.0
Linux santa 2.6.8-2-386 #1 Fri Jul 29 18:01:33 CEST 2005 i686 GNU/Linux

Regards,
Henrik

Henrik Zagerholm wrote:
> Hello list,
>
> I'm trying to install tsearch2 on a freshly created database in 8.2 but
> I get these NOTICES when doing so.
> Is this something to be concerned about?
>
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "pg_ts_dict_pkey" for table "pg_ts_dict"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "pg_ts_parser_pkey" for table "pg_ts_parser"

Anything marked "NOTICE" is fine. Here the server is letting you know
something happened without you explicitly asking for it (creating an index).

--
   Richard Huxton
   Archonet Ltd