From: Alexander Schneider <edv-beratung.schneider@gmx.de>
To: PostgreSQL Mailinglist <pgsql-sql@postgreSQL.org>
Subject: FullTextIndex Problems on Update
Date: Tue, 15 Jun 1999 13:04:56 +0200
Message-ID: <199906151104.HAA70474@hub.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: edv-beratung.schneider@gmx.de
Subject: Re: FullTextIndex Problems on Update
In-Reply-To: <199906151104.HAA70474@hub.org>
References: <199906151104.HAA70474@hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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