Re: impact of version upgrade on fts

2021-04-26 Thread Malik Rumi
Thanks, I'll check it out. *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Sun, Apr 25, 2021 at 2:32 PM Robert Treat wrote: > On Sun, Apr 25, 2021 at 11:27 AM Adrian Klaver > wrote: > > > > On 4/25/21 5:

impact of version upgrade on fts

2021-04-25 Thread Malik Rumi
Greetings. I am about to do a long overdue upgrade to the latest version, which I believe is 13.2. However, I have full text search in my current install (9.4) and I am wondering if there are any special provisions I need to take to make sure that is not lost in the transition? If this would be t

Re: Triggers and Full Text Search *

2020-04-25 Thread Malik Rumi
apologies - I did not look closely at the manual. Many many years ago > (6.xx days I had a similar problem and leapt to answer). > > Could you post your CREATE TRIGGER statements as well? > > > On Wed, Apr 22, 2020 at 1:21 AM Malik Rumi wrote: > >> @Ericson, >> Fo

Re: Triggers and Full Text Search *

2020-04-21 Thread Malik Rumi
END; Thank you! *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Tue, Apr 21, 2020 at 1:05 PM Ericson Smith wrote: > I think COPY bypasses the triggers. > > Best Regards > - Ericson Smith > +1 876-375-9857 (wh

Triggers and Full Text Search *

2020-04-21 Thread Malik Rumi
More than a year ago, I implemented full text search on one of my sites. >From the beginning, there was one problem (or at least, what I perceive to be a problem): when I use a script to insert many documents at once, they do *not* get indexed in fts. If a document is created or inserted one at a t

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

2018-10-09 Thread Malik Rumi
system is ready to accept connections 2018-10-09 07:59:51.617 CDT [1274] [unknown]@[unknown] LOG: incomplete startup packet *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Mon, Oct 8, 2018 at 6:36 PM Adrian Klaver wrote: > On 10/8/18 3

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

2018-10-08 Thread Malik Rumi
t']) my_entry.tags.add(row['tag']) *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Mon, Oct 8, 2018 at 3:32 PM Adrian Klaver wrote: > On 10/8/18 1:25 PM, Malik Rumi wrote: > > I hope this comes out readable. I

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

2018-10-08 Thread Malik Rumi
y_tags.entry_id $ LEFT JOIN ktab_tag AS tag ON tag.id = entry_tags.tag_id WHERE entry.id = NEW.id GROUP BY entry.id, category; RETURN NEW; END; $function$ *“None of you has faith until he loves for his brother or his n

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

2018-10-08 Thread Malik Rumi
ote: > 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 &g

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

2018-10-02 Thread Malik Rumi
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