Re: DISABLE TRIGGER doc wrong?

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: DISABLE TRIGGER doc wrong?
Date: 2025-08-25 16:33:39
Message-ID: CAFCRh-83ktPQ+3nWNfSoim1AGW9-j7evaZRyOqyA=_DJ3RUn9w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 25, 2025 at 6:24 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 8/25/25 09:19, Dominique Devienne wrote:
> > 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?
>
> From the sentence before the above:
>
> "... internally generated constraint triggers, such as those that are
> used to implement foreign key constraints or deferrable uniqueness and
> exclusion constraints)."

And? I don't see your point Adrian.
Has no bearing on the SUPERUSER requirement, in my reading.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2025-08-25 17:12:50 Re: DISABLE TRIGGER doc wrong?
Previous Message Adrian Klaver 2025-08-25 16:24:50 Re: DISABLE TRIGGER doc wrong?