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@visena.com <mailto:andreas@visena.com>> wrote:
> 
>     På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi
>     <malik.a.rumi@gmail.com <mailto:malik.a.rumi@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 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.klaver@aklaver.com