pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedimporting a 7.2 db with contrib/tsearch to 7.3
2+ messages / 2 participants
[nested] [flat]
* importing a 7.2 db with contrib/tsearch to 7.3
@ 2002-11-21 10:55 Andreas Joseph Krogh <andreak@officenet.no>
2002-11-21 11:13 ` Re: importing a 7.2 db with contrib/tsearch to 7.3 Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 2+ messages in thread
From: Andreas Joseph Krogh @ 2002-11-21 10:55 UTC (permalink / raw)
To: pgsql-sql
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 <andreak@officenet.no>
- Only two things are infinite, the universe and human stupidity, and
I'm not sure about the former.
Albert Einstein
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: importing a 7.2 db with contrib/tsearch to 7.3
2002-11-21 10:55 importing a 7.2 db with contrib/tsearch to 7.3 Andreas Joseph Krogh <andreak@officenet.no>
@ 2002-11-21 11:13 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Achilleus Mantzios @ 2002-11-21 11:13 UTC (permalink / raw)
To: Andreas Joseph Krogh <andreak@officenet.no>; +Cc: pgsql-sql
Thats what i do for intarray:
-Install all contrib packages you want to use (*before* restoring
your DB)
-Restore Your DB
-Look in log for errors
-Correct them.
Normally all you shoud get is a bunch of notices that somethings
are allready defined.
I had the same problem as you with gist indexes in intarray.
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-11-21 11:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-21 10:55 importing a 7.2 db with contrib/tsearch to 7.3 Andreas Joseph Krogh <andreak@officenet.no>
2002-11-21 11:13 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox