Content-Type: multipart/alternative;
 boundary="------------GGbUi6maJlbjzcvt4WLECRSJ"
Message-ID: <185dd861-4e5a-47c0-9f2e-84dfa8a406ca@postgrespro.ru>
Date: Mon, 25 Aug 2025 20:13:50 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: DISABLE TRIGGER doc wrong?
To: Dominique Devienne <ddevienne@gmail.com>,
 pgsql-general@lists.postgresql.org
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
Content-Language: en-US, ru
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/185dd861-4e5a-47c0-9f2e-84dfa8a406ca%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------GGbUi6maJlbjzcvt4WLECRSJ
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

On 25.08.2025 19:19, Dominique Devienne wrote:
> Fromhttps://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALT=
ERTABLE-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?
Simple experiment shows that it is still up to date:

postgres@postgres(17.5)=3D# set session authorization alice;
SET
alice@postgres(17.5)=3D> create table t (id int primary key, parent_id in=
t=20
references t(id));
CREATE TABLE
alice@postgres(17.5)=3D> select tgname from pg_trigger where tgrelid =3D=20
't'::regclass;
 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
 tgname
--------------------------------
 =C2=A0RI_ConstraintTrigger_a_1260370
 =C2=A0RI_ConstraintTrigger_a_1260371
 =C2=A0RI_ConstraintTrigger_c_1260372
 =C2=A0RI_ConstraintTrigger_c_1260373
(4 rows)

alice@postgres(17.5)=3D> alter table t disable trigger=20
"RI_ConstraintTrigger_a_1260370";
ERROR:=C2=A0 permission denied: "RI_ConstraintTrigger_a_1260370" is a sys=
tem=20
trigger
alice@postgres(17.5)=3D> \c - postgres
You are now connected to database "postgres" as user "postgres".
postgres@postgres(17.5)=3D# alter table t disable trigger=20
"RI_ConstraintTrigger_a_1260370";
ALTER TABLE

--=20
Pavel Luzanov
Postgres Professional:https://postgrespro.com

--------------GGbUi6maJlbjzcvt4WLECRSJ
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">On 25.08.2025 19:19, Dominique Devienn=
e
      wrote:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmai=
l.com">
      <pre class=3D"moz-quote-pre" wrap=3D""><pre wrap=3D""
      class=3D"moz-quote-pre">From <a class=3D"moz-txt-link-freetext"
href=3D"https://www.postgresql.org/docs/current/sql-altertable.html#SQL-A=
LTERTABLE-DESC-DISABLE-ENABLE-TRIGGER"
      moz-do-not-send=3D"true">https://www.postgresql.org/docs/current/sq=
l-altertable.html#SQL-ALTERTABLE-DESC-DISABLE-ENABLE-TRIGGER</a>:
</pre><blockquote type=3D"cite" style=3D"color: #007cff;"><pre wrap=3D""
      class=3D"moz-quote-pre">Disabling or enabling internally generated =
constraint triggers requires superuser privileges
</pre></blockquote><pre wrap=3D"" class=3D"moz-quote-pre">We were disabli=
ng triggers as the owner of the table just fine, no
SUPERUSER involved. So is the doc out-of-date?</pre></pre>
    </blockquote>
    Simple experiment shows that it is still up to date:<br>
    <br>
    postgres@postgres(17.5)=3D# set session authorization alice;<br>
    SET<br>
    alice@postgres(17.5)=3D&gt; create table t (id int primary key,
    parent_id int references t(id));<br>
    CREATE TABLE<br>
    alice@postgres(17.5)=3D&gt; select tgname from pg_trigger where
    tgrelid =3D 't'::regclass;<br>
    =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 tgname=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 =C2=A0<br>
    --------------------------------<br>
    =C2=A0RI_ConstraintTrigger_a_1260370<br>
    =C2=A0RI_ConstraintTrigger_a_1260371<br>
    =C2=A0RI_ConstraintTrigger_c_1260372<br>
    =C2=A0RI_ConstraintTrigger_c_1260373<br>
    (4 rows)<br>
    <br>
    alice@postgres(17.5)=3D&gt; alter table t disable trigger
    "RI_ConstraintTrigger_a_1260370";<br>
    ERROR:=C2=A0 permission denied: "RI_ConstraintTrigger_a_1260370" is a
    system trigger<br>
    alice@postgres(17.5)=3D&gt; \c - postgres <br>
    You are now connected to database "postgres" as user "postgres".<br>
    postgres@postgres(17.5)=3D# alter table t disable trigger
    "RI_ConstraintTrigger_a_1260370";<br>
    ALTER TABLE<br>
    <br>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Pavel Luzanov
Postgres Professional: <a class=3D"moz-txt-link-freetext" href=3D"https:/=
/postgrespro.com">https://postgrespro.com</a></pre>
  </body>
</html>

--------------GGbUi6maJlbjzcvt4WLECRSJ--