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