• Tom Lane's avatar
    Provide the OR REPLACE option for CREATE TRIGGER. · 92bf7e2d
    Tom Lane authored
    This is mostly straightforward.  However, we disallow replacing
    constraint triggers or changing the is-constraint property; perhaps
    that can be added later, but the complexity versus benefit tradeoff
    doesn't look very good.
    
    Also, no special thought is taken here for whether replacing an
    existing trigger should result in changes to queued-but-not-fired
    trigger actions.  We just document that if you're surprised by the
    results, too bad, don't do that.  (Note that any such pending trigger
    activity would have to be within the current session.)
    
    Takamichi Osumi, reviewed at various times by Surafel Temesgen,
    Peter Smith, and myself
    
    Discussion: https://postgr.es/m/0DDF369B45A1B44B8A687ED43F06557C010BC362@G01JPEXMBYT03
    92bf7e2d
triggers.sql 83.3 KB