On Tue, Aug 26, 2025 at 3:01 AM Dominique Devienne <[email protected]> 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!
