Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 720B7475F34 for ; Thu, 21 Nov 2002 05:59:12 -0500 (EST) Received: from krogh.officenet.no (unknown [193.212.174.47]) by postgresql.org (Postfix) with ESMTP id BD3F6475D39 for ; Thu, 21 Nov 2002 05:58:58 -0500 (EST) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by krogh.officenet.no (Postfix) with ESMTP id E830082D5E for ; Thu, 21 Nov 2002 05:55:42 -0500 (EST) From: Andreas Joseph Krogh Organization: OfficeNet AS To: pgsql-sql@postgresql.org Subject: importing a 7.2 db with contrib/tsearch to 7.3 Date: Thu, 21 Nov 2002 11:55:42 +0100 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200211211155.42539.andreak@officenet.no> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/324 X-Sequence-Number: 10466 If this is the wrong list, please redirect me to the correct one. I have a PostgreSQL-7.2 installation with several databases in it which uses the contrib/tsearch module. I've done a (on 7.2): pg_dumpall and (on 7.3): /usr/local/pgsql/bin/psql -d template1 -f prod2-pg7.2.dmp I get a bunch of theese errors in the log-file: --------------------------------------------------------------------------------------- psql:prod2-pg7.2.dmp:89: NOTICE: TypeCreate: changing argument type of function qtxt_in from OPAQUE to CSTRING psql:prod2-pg7.2.dmp:89: NOTICE: TypeCreate: changing argument type of function qtxt_out from OPAQUE to query_txt psql:prod2-pg7.2.dmp:89: NOTICE: TypeCreate: changing return type of function qtxt_in from OPAQUE to query_txt psql:prod2-pg7.2.dmp:89: NOTICE: TypeCreate: changing return type of function qtxt_out from OPAQUE to CSTRING CREATE TYPE CREATE FUNCTION psql:prod2-pg7.2.dmp:105: NOTICE: TypeCreate: changing argument type of function mqtxt_in from OPAQUE to CSTRING psql:prod2-pg7.2.dmp:105: ERROR: TypeCreate: function qtxt_out(mquery_txt) does not exist CREATE FUNCTION psql:prod2-pg7.2.dmp:121: ERROR: Type "mquery_txt" does not exist CREATE FUNCTION psql:prod2-pg7.2.dmp:137: ERROR: Type "mquery_txt" does not exist CREATE FUNCTION psql:prod2-pg7.2.dmp:153: ERROR: Type "mquery_txt" does not exist CREATE OPERATOR CREATE OPERATOR psql:prod2-pg7.2.dmp:192: ERROR: Type "mquery_txt" does not exist psql:prod2-pg7.2.dmp:205: ERROR: Type "mquery_txt" does not exist .. .. psql:prod2-pg7.2.dmp:2539: ERROR: data type txtidx has no default operator class for access method "gist" You must specify an operator class for the index or define a default operator class for the data type .. .. psql:prod2-pg7.2.dmp:4419: ERROR: execqtxt: must be owner psql:prod2-pg7.2.dmp:4427: ERROR: Type "mquery_txt" does not exist psql:prod2-pg7.2.dmp:4435: ERROR: rexecqtxt: must be owner psql:prod2-pg7.2.dmp:4443: ERROR: Type "mquery_txt" does not exist --------------------------------------------------------------------------------------- The database seems to work just fine, and one of the tables which uses the txtidx datatype looks like this in 7.2 and 7.3 respectively: e4u=> select version(); version ---------------------------------------------------------------------------------------------------- PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk) (1 row) e4u=> \d on_article_searchable Table "on_article_searchable" Column | Type | Modifiers ---------+---------+----------- id | integer | not null lang_id | integer | not null content | txtidx | Indexes: searchable_lang_idx, t_idx Primary key: on_article_searchable_pkey Triggers: RI_ConstraintTrigger_18817, RI_ConstraintTrigger_18823 ------------ e4u=> select version(); version ----------------------------------------------------------------------------------------------------- PostgreSQL 7.3rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk) (1 row) e4u=> \d on_article_searchable Table "public.on_article_searchable" Column | Type | Modifiers ---------+---------+----------- id | integer | not null lang_id | integer | not null content | txtidx | Indexes: on_article_searchable_pkey primary key btree (id, lang_id), searchable_lang_idx btree (lang_id) Triggers: RI_ConstraintTrigger_41091, RI_ConstraintTrigger_41094 Notice, the t_idx index is missing on the 7.3 table. Does that mean I have to manually "install" tsearch on each database? When I try to create the index t_idx on the table, the following error occures: e4u=> CREATE INDEX t_idx ON on_article_searchable USING gist (content); ERROR: data type txtidx has no default operator class for access method "gist" You must specify an operator class for the index or define a default operator class for the data type Any help appreciated. -- Andreas Joseph Krogh - Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. Albert Einstein