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-375-9857 (whatsapp)
> +1 646-483-3420 (sms)
>
>
>
> On Wed, Apr 22, 2020 at 12:32 AM Andreas Joseph Krogh
> <andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>> wrote:
>
> På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi
> <malik(dot)a(dot)rumi(at)gmail(dot)com <mailto:malik(dot)a(dot)rumi(at)gmail(dot)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 no point and
> we can wrap this up. But if not, I will happily post what I
> have. Thank you.
>
> This is too much prose for the regular programmer, show us the code,
> and point out what doesn't work for you, then we can help:-)
> --
> Andreas Joseph Krogh
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com