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>
In-Reply-To: <CAFCRh-8hUbi26hfD5ev4A7UwNAOhnmHf-JFpsk0StTmvaFC=Yg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 26 Aug 2025 08:53:37 -0400
Message-ID: <CANzqJaCHmh+q4GqJSXir9nXLiHVY7MWgPo4n2xaMSCwwxE5hfQ@mail.gmail.com>
Subject: Re: DISABLE TRIGGER doc wrong?
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dc9a8d063d442991"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCHmh%2Bq4GqJSXir9nXLiHVY7MWgPo4n2xaMSCwwxE5hfQ%40mail.gmail.com>
Precedence: bulk

--000000000000dc9a8d063d442991
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Aug 26, 2025 at 3:01=E2=80=AFAM Dominique Devienne <ddevienne@gmail=
.com>
wrote:
[snip]

> ERROR:  permission denied: "RI_ConstraintTrigger_c_1226298044" is a
> system trigger
>
> (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.
And it can seem quite random to someone who doesn't dig into the source
code.  For example, a couple of years ago, I installed PG14 on 5
newly-built servers.  The OIDs of the ten databases I created on them were:

Srv 1: 19762693,  544452602
Srv 2:  1002727,   11988067
Srv 3:    16388,  509694991
Srv 4:    16387, 1805148571
Srv 5:    16388, 3046645364

(Too bad Postgresql doesn't have CREATED_ON timestamp, CREATED_BY oid,
MODIFIED_ON timestamp and MODIFIED_BY oid fields in pg_database and
pg_class,to verify whether my memory is correct.  The counter-argument when
I requested such fields was "pg_dump/pg_upgrade creates new objects, so
it's not _really_ when they were created" and "you don't _really_ need
those fields".)

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Aug 26, 2025 at 3:01=E2=80=AFAM D=
ominique Devienne &lt;<a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmai=
l.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container">=
<div>[snip]=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
ERROR:=C2=A0 permission denied: &quot;RI_ConstraintTrigger_c_1226298044&quo=
t; is a<br>
system trigger<br>
<br>
(yes, that&#39;s a large OID... For a 1 year old DB)<br></blockquote></div>=
<div><br></div><div>PG&#39;s OID allocation of &quot;user-land&quot; OIDs d=
oesn&#39;t start at 16384 anymore.=C2=A0 And it can seem quite random to so=
meone who doesn&#39;t dig into the source code.=C2=A0 For example, a couple=
 of years ago, I installed PG14 on 5 newly-built servers.=C2=A0 The OIDs of=
 the ten databases I created on them were:</div><div><br></div><div><font f=
ace=3D"monospace">Srv 1:=C2=A019762693,=C2=A0 544452602</font></div><div><f=
ont face=3D"monospace">Srv 2:=C2=A0 1002727,=C2=A0 =C2=A011988067</font></d=
iv><div><font face=3D"monospace">Srv 3:=C2=A0 =C2=A0 16388,=C2=A0 509694991=
</font></div><div><font face=3D"monospace">Srv 4:=C2=A0 =C2=A0=C2=A0</font>=
<span style=3D"font-family:monospace">16387,=C2=A0</span><span style=3D"fon=
t-family:monospace">1</span><span style=3D"font-family:monospace">805148571=
</span></div><div><font face=3D"monospace">Srv 5:=C2=A0 =C2=A0=C2=A0</font>=
<span style=3D"font-family:monospace">16388,=C2=A0</span><span style=3D"fon=
t-family:monospace">3046645364</span></div><div><br></div><div>(Too bad Pos=
tgresql doesn&#39;t have CREATED_ON timestamp, CREATED_BY oid, MODIFIED_ON =
timestamp and MODIFIED_BY oid fields in pg_database and pg_class,to verify =
whether my memory is correct.=C2=A0 The counter-argument when I requested s=
uch fields was &quot;pg_dump/pg_upgrade creates new objects, so it&#39;s no=
t _really_ when they were created&quot; and &quot;you don&#39;t _really_ ne=
ed those fields&quot;.)</div><div><br></div><span class=3D"gmail_signature_=
prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me=
, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></=
div></div></div></div>

--000000000000dc9a8d063d442991--