Received: from mail1.gmx.net (mail1.gmx.net [194.221.183.61]) by hub.org (8.9.3/8.9.3) with SMTP id HAA70474 for ; Tue, 15 Jun 1999 07:04:45 -0400 (EDT) (envelope-from edv-beratung.schneider@gmx.de) Message-Id: <199906151104.HAA70474@hub.org> Received: (qmail 12353 invoked by uid 0); 15 Jun 1999 11:04:39 -0000 Received: from unknown (HELO ?192.168.147.132?) (193.175.163.144) by mail1.gmx.net with SMTP; 15 Jun 1999 11:04:39 -0000 Subject: FullTextIndex Problems on Update Date: Tue, 15 Jun 1999 13:04:56 +0200 x-sender: 239972@pop.gmx.net 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" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id HAA70482 Hello, 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