Received: from mailweb30.rediffmail.com ([203.199.83.150]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8N4lGe35857 for ; Sun, 23 Sep 2001 00:47:16 -0400 (EDT) (envelope-from sameermaggon@rediffmail.com) Received: (qmail 20052 invoked by uid 510); 23 Sep 2001 05:01:08 -0000 Date: 23 Sep 2001 05:01:08 -0000 Message-ID: <20010923050108.20051.qmail@mailweb30.rediffmail.com> Received: from unknown (202.89.64.23) by rediffmail.com via HTTP; 23 Sep 2001 05:01:08 -0000 MIME-Version: 1.0 To: "Neophytos Demetriou" Subject: OpenFTS From: "Sameer Maggon" Content-ID: Content-type: text/plain Content-Description: Body Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200109/57 X-Sequence-Number: 991 When i tried out the examples from primer... Some problems occured $psql testfts < _int.sql CREATE FUNCTION g_intbig_compress(opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* CREATE FUNCTION g_intbig_decompress(opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* CREATE FUNCTION g_intbig_penalty(opaque,opaque,opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* CREATE FUNCTION g_intbig_picksplit(opaque, opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* CREATE FUNCTION g_intbig_union(bytea, opaque) RETURNS _int4 AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* CREATE FUNCTION g_intbig_same(_int4, _int4, opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/lib_int.so.1.0' LANGUAGE 'c'; NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* -- register the default opclass for indexing INSERT INTO pg_opclass (opcname, opcdeftype) values ( 'gist__intbig_ops', 0 ); NOTICE: current transaction is aborted, queries ignored until end of trans= actio n block *ABORT STATE* NEXT I TRIED $ ./init.pl testfts Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-lin= ux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/li= b/perl5/site_perl/5.005 .) at ./init.pl line 5. BEGIN failed--compilation aborted at ./init.pl line 5. Please help =20