Thread

  1. Out of date docs: DISABLE/ENABLE TRIGGER

    Dean Rasheed <dean.a.rasheed@gmail.com> — 2010-06-06T09:11:02Z

    Hi,
    
    I just spotted that the docs for ALTER TABLE .. DISABLE/ENABLE TRIGGER
    are out of date, now that we have deferrable uniqueness and exclusion
    constraints.
    
    Also, I think that the original comment in the ENABLE/DISABLE TRIGGER
    section was misleading because it suggested that only superusers can
    disable constraint triggers, which is not true for *user-defined*
    constraint triggers.
    
    Proposed update attached.
    
    Regards,
    Dean
    
  2. Re: Out of date docs: DISABLE/ENABLE TRIGGER

    Alvaro Herrera <alvherre@commandprompt.com> — 2010-06-09T17:48:57Z

    Excerpts from Dean Rasheed's message of dom jun 06 05:11:02 -0400 2010:
    > Hi,
    > 
    > I just spotted that the docs for ALTER TABLE .. DISABLE/ENABLE TRIGGER
    > are out of date, now that we have deferrable uniqueness and exclusion
    > constraints.
    
    applied, thanks
    
    > Also, I think that the original comment in the ENABLE/DISABLE TRIGGER
    > section was misleading because it suggested that only superusers can
    > disable constraint triggers, which is not true for *user-defined*
    > constraint triggers.
    
    right.
    
    -- 
    Álvaro Herrera <alvherre@commandprompt.com>
    The PostgreSQL Company - Command Prompt, Inc.
    PostgreSQL Replication, Consulting, Custom Development, 24x7 support