Re: Triggers and Full Text Search *

@Ericson I have the script (statements?) by which I created the triggers, but since you asked I do not see them in pga4, from which I manage my postgres. I don't know if this is significant or not. Also, this was originally done quite a while ago, so my memory may be fuzzy. From the text of the sta

Re: Triggers and Full Text Search *

On Tue, 2020-04-21 at 12:24 -0500, Malik Rumi wrote: > 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 ind

Re: Triggers and Full Text Search *

On 4/21/20 11:21 AM, Malik Rumi wrote: @Ericson, Forgive me for seeming dense, but how does COPY help or hurt here? @Andreas, I had to laugh at your reference to "prose". Would you believe I am actually a published playwright? Long before I started coding, of course. Old habits die hard.

Re: Triggers and Full Text Search *

My 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, > Forgive me for seeming dense, but how does CO

Re: Triggers and Full Text Search *

@Ericson, Forgive me for seeming dense, but how does COPY help or hurt here? @Andreas, I had to laugh at your reference to "prose". Would you believe I am actually a published playwright? Long before I started coding, of course. Old habits die hard. entry_search_vector_trigger BEG

Re: Triggers and Full Text Search *

On 4/21/20 11:04 AM, Ericson Smith wrote: I think COPY bypasses the triggers. No: https://www.postgresql.org/docs/12/sql-copy.html "COPY FROM will invoke any triggers and check constraints on the destination table. However, it will not invoke rules." Best Regards - Ericson Smith +1 876-3

Re: Triggers and Full Text Search *

I think COPY bypasses the triggers. Best Regards - Ericson Smith +1 876-375-9857 (whatsapp) +1 646-483-3420 (sms) On Wed, Apr 22, 2020 at 12:32 AM Andreas Joseph Krogh wrote: > På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi < > malik.a.r...@gmail.com>: > > [...] > > I am not (yet) p

Sv: Triggers and Full Text Search *

På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi < malik.a.r...@gmail.com >: [...] I am not (yet) posting the trigger code because this post is long already, and if your answers are 1) yes, 2) no and 3) triggers often work / fail like this, then there’s

Triggers and Full Text Search *

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