1. This code is entry_search_vector_trigger(), one of 3 trigger functions based on the Django model that created the site. 2. So this is the trigger definition (as far as I know) and it is on the Entry table. There is also a Tag table and the Tags intersection table. 3. Uhh, I'm not sure. I assume this is it, that when a new entry is posted, the function that parses the entry into searchable text and indexes the words is called. But I can tell you I got this code from this blog post: blog.lotech.org/postgres-full-text-search-with-django.html. I asked the author about this issue. He said he wasn't sure wthout debugging if it was something he left out or something I did wrong. 4. Postgresql 9.4. Yea, I know, I should upgrade...
*“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Tue, Oct 2, 2018 at 6:27 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > 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.kla...@aklaver.com >
