MIME-Version: 1.0
References: <CAFCRh--VRAHh2D7PsvW1mgRFfx2bqLQH_8asEBTLBn3RDLT7tA@mail.gmail.com>
 <185dd861-4e5a-47c0-9f2e-84dfa8a406ca@postgrespro.ru> <CAFCRh-85iWNy51sQBiVtwE=xq_pEhqR_cOetTa0-DK9TCjqQyw@mail.gmail.com>
 <26239cd6-a13d-4137-9f1d-61e18c4cf0e6@aklaver.com>
In-Reply-To: <26239cd6-a13d-4137-9f1d-61e18c4cf0e6@aklaver.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Tue, 26 Aug 2025 09:01:32 +0200
Message-ID: <CAFCRh-8hUbi26hfD5ev4A7UwNAOhnmHf-JFpsk0StTmvaFC=Yg@mail.gmail.com>
Subject: Re: DISABLE TRIGGER doc wrong?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Pavel Luzanov <p.luzanov@postgrespro.ru>, pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-8hUbi26hfD5ev4A7UwNAOhnmHf-JFpsk0StTmvaFC%3DYg%40mail.gmail.com>
Precedence: bulk

On Mon, Aug 25, 2025 at 7:33=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com> wrote:
> On 8/25/25 10:24, Dominique Devienne wrote:
> > On Mon, Aug 25, 2025 at 7:13=E2=80=AFPM Pavel Luzanov <p.luzanov@postgr=
espro.ru> wrote:
> >> On 25.08.2025 19:19, Dominique Devienne wrote:
> >> Simple experiment shows that it is still up to date:

Thanks Pavel. Indeed. See below.

> I am not seeing it:

Thanks Adrian. Indeed, it was my mistake.

I thought the 4 tables we had USER triggers on also had FKs, but I was mist=
aken.

I just tried on the 5th (and last) one we're adding triggers on, which
does have an FK, and I do get the documented (and verified by you
guys) error:

ERROR:  permission denied: "RI_ConstraintTrigger_c_1226298044" is a
system trigger

(yes, that's a large OID... For a 1 year old DB)

I apologize for wasting your time. Thanks, --DD