From: | Alexander Schneider <edv-beratung(dot)schneider(at)gmx(dot)de> |
---|---|
To: | "PostgreSQL Mailinglist" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | FullTextIndex Problems on Update |
Date: | 1999-06-15 11:04:56 |
Message-ID: | 199906151104.HAA70474@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Maarten Boekhold | 1999-06-15 11:52:32 | Re: [SQL] Full-Text-Indexing |
Previous Message | Michael Olivier | 1999-06-15 05:23:45 | example of trigger to track DB changes |