Index: README.fti =================================================================== RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/README.fti,v retrieving revision 1.4 diff -c -r1.4 README.fti *** README.fti 2002/08/22 00:01:38 1.4 --- README.fti 2002/09/02 02:09:27 *************** *** 50,56 **** Now, how do we create the trigger that maintains the fti-table? First: the fti-table should have the following schema: ! create cds-fti ( string varchar(N), id oid ); Don't change the *names* of the columns, the varchar() can in fact also be of text-type. If you do use varchar, make sure the largest possible --- 50,56 ---- Now, how do we create the trigger that maintains the fti-table? First: the fti-table should have the following schema: ! create cds-fti ( string varchar(N), id oid ) without oids; Don't change the *names* of the columns, the varchar() can in fact also be of text-type. If you do use varchar, make sure the largest possible Index: fti.c =================================================================== RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/fti.c,v retrieving revision 1.19 diff -c -r1.19 fti.c *** fti.c 2002/09/02 01:05:03 1.19 --- fti.c 2002/09/02 02:09:27 *************** *** 25,31 **** * '/usr/local/pgsql/lib/contrib/fti.so' language 'C'; * * -- Create the FTI table ! * create table product_fti (string varchar(255), id oid); * * -- Create an index to assist string matches * create index product_fti_string_idx on product_fti (string); --- 25,31 ---- * '/usr/local/pgsql/lib/contrib/fti.so' language 'C'; * * -- Create the FTI table ! * create table product_fti (string varchar(255), id oid) without oids; * * -- Create an index to assist string matches * create index product_fti_string_idx on product_fti (string); Index: fti.sql.in =================================================================== RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/fti.sql.in,v retrieving revision 1.4 diff -c -r1.4 fti.sql.in *** fti.sql.in 2002/08/22 00:01:38 1.4 --- fti.sql.in 2002/09/02 02:09:27 *************** *** 1,3 **** ! create function fti() returns trigger as ! 'MODULE_PATHNAME' ! language 'C'; \ No newline at end of file --- 1,3 ---- ! CREATE OR REPLACE FUNCTION fti() RETURNS trigger AS ! 'MODULE_PATHNAME', 'fti' ! LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT;