pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Schneider <alex@alexander-schneider.de>
To: PostgreSQL Mailinglist <pgsql-sql@postgreSQL.org>
Subject: FullTextIndex Problems on Update
Date: Tue, 15 Jun 1999 14:21:03 +0200
Message-ID: <1282673016-67441409@mail.isolution.de> (raw)

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



view thread (2+ messages)

Message-ID: <1282673016-67441409@mail.isolution.de>
Permalink:  ../1282673016-67441409@mail.isolution.de/
Also on:    postgresql.org/message-id/1282673016-67441409@mail.isolution.de

 · 

reply

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: alex@alexander-schneider.de
  Subject: Re: FullTextIndex Problems on Update
  In-Reply-To: <1282673016-67441409@mail.isolution.de>
  References: <1282673016-67441409@mail.isolution.de>

* 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