tsearch2 migration 8.2 --> 8.3

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: postgres admin <pgsql-admin(at)postgresql(dot)org>
Subject: tsearch2 migration 8.2 --> 8.3
Date: 2009-02-16 20:44:05
Message-ID: a97c77030902161244y9542228g7b7affc960e8ae6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2009-02-17 08:54:52 8.3.5 broken after power fail
Previous Message Scott Marlowe 2009-02-16 20:01:15 Re: Downtime