pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
FullTextIndex Problems on Update 2+ messages / 2 participants [nested] [flat]
* FullTextIndex Problems on Update @ 1999-06-15 11:04 Alexander Schneider <edv-beratung.schneider@gmx.de> 0 siblings, 0 replies; 2+ messages in thread From: Alexander Schneider @ 1999-06-15 11:04 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* FullTextIndex Problems on Update @ 1999-06-15 12:21 Alexander Schneider <alex@alexander-schneider.de> 0 siblings, 0 replies; 2+ messages in thread From: Alexander Schneider @ 1999-06-15 12:21 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-06-15 12:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-06-15 11:04 FullTextIndex Problems on Update Alexander Schneider <edv-beratung.schneider@gmx.de> 1999-06-15 12:21 FullTextIndex Problems on Update Alexander Schneider <alex@alexander-schneider.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox