Feedback-ID: i76984098:Fastmail
Message-ID: <26239cd6-a13d-4137-9f1d-61e18c4cf0e6@aklaver.com>
Date: Mon, 25 Aug 2025 10:33:35 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: DISABLE TRIGGER doc wrong?
To: Dominique Devienne <ddevienne@gmail.com>,
 Pavel Luzanov <p.luzanov@postgrespro.ru>
Cc: pgsql-general@lists.postgresql.org
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
 <185dd861-4e5a-47c0-9f2e-84dfa8a406ca@postgrespro.ru>
 <CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/26239cd6-a13d-4137-9f1d-61e18c4cf0e6%40aklaver.com>
Precedence: bulk

On 8/25/25 10:24, Dominique Devienne wrote:
> On Mon, Aug 25, 2025 at 7:13 PM Pavel Luzanov <p.luzanov@postgrespro.ru> wrote:
>> On 25.08.2025 19:19, Dominique Devienne wrote:
>> Simple experiment shows that it is still up to date:
> 
>> alice@postgres(17.5)=> alter table t disable trigger "RI_ConstraintTrigger_a_1260370";
>> ERROR:  permission denied: "RI_ConstraintTrigger_a_1260370" is a system trigger
>> alice@postgres(17.5)=> \c - postgres
>> You are now connected to database "postgres" as user "postgres".
>> postgres@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
> 
> 

I am not seeing it:


select version();
                                                               version 

-----------------------------------------------------------------------------------------------------------------------------------
  PostgreSQL 17.6 (Ubuntu 17.6-1.pgdg22.04+1) on x86_64-pc-linux-gnu, 
compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit


create table test_table_parent(id integer primary key, fld varchar);
create table test_table_child(id integer primary key, fld_child varchar, 
parent_id integer references test_table_parent on update cascade);

\dt+ test_table_child
                                             List of tables
  Schema |       Name       | Type  |  Owner  | Persistence | Access 
method |    Size    | Description
--------+------------------+-------+---------+-------------+---------------+------------+-------------
  public | test_table_child | table | db_user | permanent   | heap 
    | 8192 bytes | NULL


\du+ db_user
             List of roles
  Role name | Attributes | Description
-----------+------------+-------------
  db_user   |            |

alter table test_table_child disable  trigger all;
ERROR:  permission denied: "RI_ConstraintTrigger_c_121933" is a system 
trigger


-- 
Adrian Klaver
adrian.klaver@aklaver.com