tsearch2 migration 8.2 --> 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux