public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: DISABLE TRIGGER doc wrong?
Date: Mon, 25 Aug 2025 19:12:50 +0200
Message-ID: <CAFCRh-9r8M1Y+nW5quojN6NKUUjcSHvUB01JPscGtG1nbL8oSA@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh-83ktPQ+3nWNfSoim1AGW9-j7evaZRyOqyA=_DJ3RUn9w@mail.gmail.com>
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
	<[email protected]>
	<CAFCRh-83ktPQ+3nWNfSoim1AGW9-j7evaZRyOqyA=_DJ3RUn9w@mail.gmail.com>

On Mon, Aug 25, 2025 at 6:33 PM Dominique Devienne <[email protected]> wrote:
> On Mon, Aug 25, 2025 at 6:24 PM Adrian Klaver <[email protected]> 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-TRIGG...:
> > >> 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.

OK, maybe my initial was poorly worded. Let me try again:

We were ALTER TABLE {}.{} DISABLE TRIGGER ALL as the table owner.

ALL includes "internally generated constraint triggers", FKs in our case.
Yet the doc clearly states one must be SUPERUSER to do that.

Thus the doc should say "requires owning the altered table, or have
superuser privileges", no?

Hope this is a clearer inquiry. Thanks, --DD

view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: DISABLE TRIGGER doc wrong?
  In-Reply-To: <CAFCRh-9r8M1Y+nW5quojN6NKUUjcSHvUB01JPscGtG1nbL8oSA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox