MIME-Version: 1.0
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
 <3a6e840a-5c30-4eed-9e5b-474dafc6c29f@aklaver.com>
In-Reply-To: <3a6e840a-5c30-4eed-9e5b-474dafc6c29f@aklaver.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 25 Aug 2025 18:33:39 +0200
Message-ID: <CAFCRh-83ktPQ+3nWNfSoim1AGW9-j7evaZRyOqyA=_DJ3RUn9w@mail.gmail.com>
Subject: Re: DISABLE TRIGGER doc wrong?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-83ktPQ%2B3nWNfSoim1AGW9-j7evaZRyOqyA%3D_DJ3RUn9w%40mail.gmail.com>
Precedence: bulk

On Mon, Aug 25, 2025 at 6:24=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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-A=
LTERTABLE-DESC-DISABLE-ENABLE-TRIGGER:
> >> Disabling or enabling internally generated constraint triggers require=
s 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.