MIME-Version: 1.0
References: <CAFCRh--J4F0hFm_+x4rwW5eLEZnz_fNcp05Q1whO4YoKnQgJpg@mail.gmail.com>
 <CANzqJaC40fS+bHNbPVjmSbRwdNHs8ZbxPUbDrJeC2hFyB9z0FQ@mail.gmail.com>
 <CAFCRh-931skmWJtK7m09jVUAV4aEFDFndaCC_d8HBQCoNmtHoQ@mail.gmail.com>
 <CAFCRh-_NEPF+WZyL90fTjA5dpETeqb70rC+Sb4X+QX+cpdgQnw@mail.gmail.com> <CANzqJaAWuD+JBk03Q02=UBLAPBsOonyww7xsPon9Op_zk-4EDw@mail.gmail.com>
In-Reply-To: <CANzqJaAWuD+JBk03Q02=UBLAPBsOonyww7xsPon9Op_zk-4EDw@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 20 Apr 2026 15:30:53 +0200
Message-ID: <CAFCRh-_8qobQf7MDPFAo0qytSK78W+ugY03JXzbJ5++X+v0HJA@mail.gmail.com>
Subject: Re: Test cluster with high OIDs above the signed-int limit (2B+)
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-_8qobQf7MDPFAo0qytSK78W%2BugY03JXzbJ5%2B%2BX%2Bv0HJA%40mail.gmail.com>
Precedence: bulk

On Mon, Apr 20, 2026 at 3:23=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:
> It's an unsigned integer, so I'd say not use signed ints when processing =
OIDs.

Well duh, that's why it's a bug.
But it's a sneaky bug, because clusters rarely enter that high-OID territor=
y.
That's precisely why I'd like a way to provoke it.

> It's a valid question, though, what happens when the OID counter wraps ar=
ound and hits a duplicate.

Again, I'm NOT interested in OID wrap-around. But the "second-half" of
the OID space.