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> <CAFCRh-8hUbi26hfD5ev4A7UwNAOhnmHf-JFpsk0StTmvaFC=Yg@mail.gmail.com>
 <CANzqJaCHmh+q4GqJSXir9nXLiHVY7MWgPo4n2xaMSCwwxE5hfQ@mail.gmail.com>
In-Reply-To: <CANzqJaCHmh+q4GqJSXir9nXLiHVY7MWgPo4n2xaMSCwwxE5hfQ@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Tue, 26 Aug 2025 15:01:16 +0200
Message-ID: <CAFCRh-9hgN5r+PL2AUJqnx-LwpckYd-nHRdCBajAonUJFo2fnQ@mail.gmail.com>
Subject: Re: DISABLE TRIGGER doc wrong?
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <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-9hgN5r%2BPL2AUJqnx-LwpckYd-nHRdCBajAonUJFo2fnQ%40mail.gmail.com>
Precedence: bulk

On Tue, Aug 26, 2025 at 2:54=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:
> On Tue, Aug 26, 2025 at 3:01=E2=80=AFAM Dominique Devienne <ddevienne@gma=
il.com> wrote:
>> ERROR:  permission denied: "RI_ConstraintTrigger_c_1226298044" is a
>> (yes, that's a large OID... For a 1 year old DB)
>
> PG's OID allocation of "user-land" OIDs doesn't start at 16384 anymore.

This is a 17 cluster. So not even 1 year old then.
So getting to 1.2B OIDs in 10 months,
doesn't bode well for the longevity of that cluster.
But we're getting OT here.
This is not a "production" server, lots of CIs and manual testing there.