Tsearch2 install on postgres 8.2 NOTICE messages

Started by Henrik Zagerholmover 19 years ago2 messagesgeneral
Jump to latest
#1Henrik Zagerholm
henke@mac.se

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

#2Richard Huxton
dev@archonet.com
In reply to: Henrik Zagerholm (#1)
Re: Tsearch2 install on postgres 8.2 NOTICE messages

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