On 10/2/18 10:34 AM, Malik Rumi wrote:
I have set up Postgres FTS on a Django/Python web site, and it works as
expected except for this one thing. When I wrote a script to bulk insert
legacy docs, the script works fine but the FTS trigger does not fire. I
have to go back and open each document one at a time to get them indexed.
What am I missing to make this work? Thanks.
Have no idea as there is not enough information.
To begin with:
1) What is code below?
2) What is the trigger definition and on what table?
3) What is the function the trigger is calling?
4) For good measure what version of Postgres?
BEGIN
SELECT setweight(to_tsvector(NEW.title), 'A') ||
setweight(to_tsvector(NEW.content), 'B') ||
setweight(to_tsvector(NEW.category), 'D') ||
setweight(to_tsvector(COALESCE(string_agg(tag.tag,
', '), '')), 'C')
INTO NEW.search_vector
FROM ktab_entry AS entry
LEFT JOIN ktab_entry_tags AS entry_tags ON
entry_tags.entry_id = entry.id <http://entry.id>
LEFT JOIN ktab_tag AS tag ON tag.id <http://tag.id> =
entry_tags.tag_id
WHERE entry.id <http://entry.id> = NEW.id
GROUP BY entry.id <http://entry.id>, category;
RETURN NEW;
END;
*/“None of you has faith until he loves for his brother or his neighbor
what he loves for himself.”/*
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
