• Alvaro Herrera's avatar
    Fix cloning of row triggers to sub-partitions · 1fa846f1
    Alvaro Herrera authored
    When row triggers exist in partitioned partitions that are not either
    part of FKs or deferred unique constraints, they are not correctly
    cloned to their partitions.  That's because they are marked "internal",
    and those are purposefully skipped when doing the clone triggers dance.
    Fix by relaxing the condition on which internal triggers are skipped.
    
    Amit Langote initially diagnosed the problem and proposed a fix, but I
    used a different approach.
    
    Reported-by: Petr Fedorov
    Discussion: https://postgr.es/m/6b3f0646-ba8c-b3a9-c62d-1c6651a1920f@phystech.edu
    1fa846f1
triggers.sql 75.2 KB