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@xxxxxxxxxx <mailto:andreas@xxxxxxxxxx>> wrote:
På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi
<malik.a.rumi@xxxxxxxxx <mailto:malik.a.rumi@xxxxxxxxx>>:
[...]
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@xxxxxxxxxxx
