• Tom Lane's avatar
    Change FK trigger naming convention to fix self-referential FKs. · 1e3b21dd
    Tom Lane authored
    Use names like "RI_ConstraintTrigger_a_NNNN" for FK action triggers and
    "RI_ConstraintTrigger_c_NNNN" for FK check triggers.  This ensures the
    action trigger fires first in self-referential cases where the very same
    row update fires both an action and a check trigger.  This change provides
    a non-probabilistic solution for bug #6268, at the risk that it could break
    client code that is making assumptions about the exact names assigned to
    auto-generated FK triggers.  Hence, change this in HEAD only.  No need for
    forced initdb since old triggers continue to work fine.
    1e3b21dd
tablecmds.c 291 KB