Received: from mail.isolution.de (mail.netarchitects.technopark.gmd.de [193.175.164.98]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA07398 for ; Tue, 15 Jun 1999 08:21:26 -0400 (EDT) (envelope-from alex@alexander-schneider.de) Received: from [192.168.147.132] (193.175.164.97) by mail.isolution.de with SMTP (Eudora Internet Mail Server 2.2.2); Tue, 15 Jun 1999 14:24:40 +0200 Subject: FullTextIndex Problems on Update Date: Tue, 15 Jun 1999 14:21:03 +0200 x-sender: alex%alexander-schneider.de@mail.alexander-schneider.de x-mailer: Claris Emailer 2.0v3, January 22, 1998 From: Alexander Schneider To: "PostgreSQL Mailinglist" Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Message-ID: <1282673016-67441409@mail.isolution.de> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id IAA07406 Sorry, but I didnīt know that I have to submit my questions through the account I receive this list. :-) Here is the original message again: I compiled the "FTI"-source from /contrib/fulltextindex and everything works well until I make an update of a row. After this everything is deleted and the new content is not added. These are the statements I used: create function fti() returns opaque as '/usr/bin/fti.so' language 'C'; create index cds_fti_idx1 on cds_fti (string); create index cds_fti_idx2 on cds_fti (string,id); create index title_idx1 on title (oid); create trigger cds_fti_tr_fname after update or insert or delete on title for each row execute procedure fti(cds _fti, cdsname); create trigger cds _fti_tr_kbeschr after update or insert or delete on title for each row execute procedure fti(cds_fti, description); create trigger cds _fti_tr_beschr after update or insert or delete on title for each row execute procedure fti(cds_fti, longdescr); I wanted to search all three fields and am not fluent in C so I donīt know if one can only full-text-index one field of a table. Tanx for any help Alexander Schneider