From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: postgres admin <pgsql-admin@postgresql.org>
Subject: tsearch2 migration 8.2 --> 8.3
Date: Tue, 17 Feb 2009 02:14:05 +0530
Message-ID: <a97c77030902161244y9542228g7b7affc960e8ae6@mail.gmail.com> (raw)
Hi,
I am attempting to migrate 8.2 database to 8.3 database , the database
uses tsearch2. The contrib module tsearch2 that is supposed to
provide backward compatibility is also installed. It has been observed
that inspite of install the contrib module some functions referred in
the 8.2 dump is neither provided by the core nor the contrib.
Eg
CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq
AS '$libdir/tsearch2', 'gtsq_in'
LANGUAGE c STRICT;
ERROR: could not find function "gtsq_in" in file
"/usr/local/pgsql/lib/tsearch2.so"
ALTER FUNCTION public.gtsq_in(cstring) OWNER TO postgres;
ERROR: function public.gtsq_in(cstring) does not exist
CREATE FUNCTION gtsq_out(gtsq) RETURNS cstring
AS '$libdir/tsearch2', 'gtsq_out'
LANGUAGE c STRICT;
ERROR: could not find function "gtsq_out" in file
"/usr/local/pgsql/lib/tsearch2.so"
ALTER FUNCTION public.gtsq_out(gtsq) OWNER TO postgres;
ERROR: function public.gtsq_out(gtsq) does not exist
On attempting to delete the type that uses these in/out functions it
is observed that they do not touch in table columns or indexes.
eg
bric=# begin work; drop type gtsq cascade; rollback;
BEGIN
NOTICE: drop cascades to function gtsq_in(cstring)
NOTICE: drop cascades to function gtsq_out(gtsq)
NOTICE: drop cascades to function gtsq_consistent(gtsq,internal,integer)
NOTICE: drop cascades to operator class gist_tp_tsquery_ops for
access method gist
NOTICE: drop cascades to function gtsq_same(gtsq,gtsq,internal)
DROP TYPE
ROLLBACK
My Question is is it safe to drop that type and migrate ?
Regds
mallah
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mallah.rajesh@gmail.com
Subject: Re: tsearch2 migration 8.2 --> 8.3
In-Reply-To: <a97c77030902161244y9542228g7b7affc960e8ae6@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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