Re: FTS trigger works 1 at a time, but fails with bulk insert script

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(dot)klaver(at)aklaver(dot)com