Dave Page <dpage@pgadmin.org> writes:
> On Mon, 16 May 2022 at 15:06, David Steele <david@pgmasters.net> wrote:
>> Out solution was to use the constant:
>>
>> #define FirstNormalObjectId 16384
>>
>> And treat anything below that as a system oid. This constant has not
>> changed in a very long time (if ever) but we added it to our list of
>> constants to recheck with each release.
> Yes, that seems reasonable. Changing that value would very likely break
> pg_upgrade I can imagine, so I suspect it'll stay as it is for a while
> longer.
Yeah, raising that would be extremely painful for pg_upgrade.
I think that when we approach the point where the system OID range
is saturated, we'll give up the principle of system OIDs being
globally unique instead of doing that. There's no fundamental
reason why unique-per-catalog wouldn't be good enough, and letting
that be the standard would give us many more years of breathing room.
regards, tom lane