trigger problem?
От | Oren Teich |
---|---|
Тема | trigger problem? |
Дата | |
Msg-id | LDEIJMIHBGLDIEOIGPEHCEJNCBAA.teich@cobalt.com обсуждение исходный текст |
Список | pgsql-general |
I'm using the fti function that is included with the source, and seem to have run into a problem with the trigger call. I have a full text index with only around 556645 entries. I then have a few triggers defined on each of the fields I'm indexing (see end of email for part of the scheme dump). When I create a new entry with insert, everything is fine. However, if I then go back and do an update, things don't go so well. Here's a transcript where 3 fields are filled out with the text 'asdfghjkl', 'krell', and 'bryston': kb=> select * from article_fti where id = '2570499'; string | id ---------+------- kl |2570499 jkl |2570499 hjkl |2570499 ghjkl |2570499 fghjkl |2570499 dfghjkl |2570499 sdfghjkl |2570499 asdfghjkl|2570499 ll |2570499 ell |2570499 rell |2570499 krell |2570499 on |2570499 ton |2570499 ston |2570499 yston |2570499 ryston |2570499 bryston |2570499 (18 rows) kb=> update article_entry set keywords = 'testing keywords' where aid = 688; UPDATE 1 kb=> select * from article_fti where id = '2570499'; string | id -------+------- on |2570499 ton |2570499 ston |2570499 yston |2570499 ryston |2570499 bryston|2570499 (6 rows) All of a sudden, only one of the fields is getting indexed! In fact, it's the first one that the trigger is defined on. Am I just not understanding triggers here? We are running postgresql-6.5.3-1 on a 2.2.12-20smp linux box. thanks for the help, Oren Teich -------------------------- CREATE TRIGGER "article_fti_trigger_question" AFTER INSERT OR DELETE OR UPDATE ON "article_entry" FOR EACH ROW EXECUTE PROCEDURE fti ('article_fti', 'question'); CREATE TRIGGER "article_fti_trigger_response" AFTER INSERT OR DELETE OR UPDATE ON "article_entry" FOR EACH ROW EXECUTE PROCEDURE fti ('article_fti', 'response'); CREATE TRIGGER "article_fti_trigger_comment" AFTER INSERT OR DELETE OR UPDATE ON "article_entry" FOR EACH ROW EXECUTE PROCEDURE fti ('article_fti', 'comments'); CREATE TRIGGER "article_fti_trigger_keywords" AFTER INSERT OR DELETE OR UPDATE ON "article_entry" FOR EACH ROW EXECUTE PROCEDURE fti ('article_fti', 'keywords');
В списке pgsql-general по дате отправления: