public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Dominique Devienne <[email protected]>
To: Pavel Luzanov <[email protected]>
Cc: [email protected]
Subject: Re: DISABLE TRIGGER doc wrong?
Date: Mon, 25 Aug 2025 10:33:35 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com>
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
<[email protected]>
<CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com>
On 8/25/25 10:24, Dominique Devienne wrote:
> On Mon, Aug 25, 2025 at 7:13 PM Pavel Luzanov <[email protected]> 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
[email protected]
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: DISABLE TRIGGER doc wrong?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox