Re: DISABLE TRIGGER doc wrong?

On Tue, Aug 26, 2025 at 3:01 AM Dominique Devienne <ddevienne(at)gmail(dot)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".)

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