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 <andr...@visena.com <mailto:andr...@visena.com>> wrote:

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


Reply via email to