• Tom Lane's avatar
    Check for pending trigger events on far end when dropping an FK constraint. · 4e026b32
    Tom Lane authored
    When dropping a foreign key constraint with ALTER TABLE DROP CONSTRAINT,
    we refuse the drop if there are any pending trigger events on the named
    table; this ensures that we won't remove the pg_trigger row that will be
    consulted by those events.  But we should make the same check for the
    referenced relation, else we might remove a due-to-be-referenced pg_trigger
    row for that relation too, resulting in "could not find trigger NNN" or
    "relation NNN has no triggers" errors at commit.  Per bug #14431 from
    Benjie Gillam.  Back-patch to all supported branches.
    
    Report: <20161124114911.6530.31200@wrigleys.postgresql.org>
    4e026b32
tablecmds.c 363 KB