DISABLE TRIGGER doc wrong?

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: DISABLE TRIGGER doc wrong?
Date: 2025-08-25 16:19:19
Message-ID: CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

or I'm reading it wrong? --DD

From https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-DISABLE-ENABLE-TRIGGER:
> Disabling or enabling internally generated constraint triggers requires superuser privileges

We were disabling triggers as the owner of the table just fine, no
SUPERUSER involved. So is the doc out-of-date?

PS: By mistake... We were ALTER TABLE {}.{} DISABLE TRIGGER ALL
when we meant ALTER TABLE {}.{} DISABLE TRIGGER USER

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-08-25 16:24:50 Re: DISABLE TRIGGER doc wrong?
Previous Message Achilleas Mantzios 2025-08-25 16:11:26 Re: Strange deadlock with object/target of lock : transaction