Skip site navigation (1) Skip section navigation (2)

OpenFTS

From: "Sameer Maggon" <sameermaggon(at)rediffmail(dot)com>
To: "Neophytos Demetriou" <k2pts(at)cytanet(dot)com(dot)cy>
Subject: OpenFTS
Date: 2001-09-23 05:01:08
Message-ID: 20010923050108.20051.qmail@mailweb30.rediffmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
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 transactio
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 transactio
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 transactio
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 transactio
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 transactio
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 transactio
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 transactio
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-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .) at ./init.pl line 5.
BEGIN failed--compilation aborted at ./init.pl line 5.

Please help

 




pgsql-docs by date

Next:From: Roberto MelloDate: 2001-09-23 06:29:59
Subject: Re: OpenFTS
Previous:From: Sameer MaggonDate: 2001-09-23 04:50:17
Subject: OpenFTS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group