Re: DISABLE TRIGGER doc wrong?

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: DISABLE TRIGGER doc wrong?
Date: 2025-08-25 17:24:06
Message-ID: CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 25, 2025 at 7:13 PM Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru> wrote:
> On 25.08.2025 19:19, Dominique Devienne wrote:
> Simple experiment shows that it is still up to date:

> alice(at)postgres(17.5)=> alter table t disable trigger "RI_ConstraintTrigger_a_1260370";
> ERROR: permission denied: "RI_ConstraintTrigger_a_1260370" is a system trigger
> alice(at)postgres(17.5)=> \c - postgres
> You are now connected to database "postgres" as user "postgres".
> postgres(at)postgres(17.5)=# alter table t disable trigger "RI_ConstraintTrigger_a_1260370";
> ALTER TABLE

We were using ALL, successfully but incorrectly, and are now using
USER, successfully.
Not a named constraint trigger as you did. Could it be ALL implicitly
excludes such constraint triggers, when not SUPERUSER? And thus, as
the table owner, ALL == USER, implicitly? If that's the case, then the
doc still needs clarifications IMHO. --DD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-08-25 17:33:35 Re: DISABLE TRIGGER doc wrong?
Previous Message Pavel Luzanov 2025-08-25 17:13:50 Re: DISABLE TRIGGER doc wrong?