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