pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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