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.
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? |