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