Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEoix-004RQZ-0j for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 13:31:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEohw-002jXe-0X for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 13:30:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEohv-002jXT-2l for pgsql-general@lists.postgresql.org; Mon, 20 Apr 2026 13:30:35 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wEoht-000000028VZ-3U7T for pgsql-general@postgresql.org; Mon, 20 Apr 2026 13:30:35 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-6948b5b1c53so317733eaf.1 for ; Mon, 20 Apr 2026 06:30:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776691832; cv=none; d=google.com; s=arc-20240605; b=kuZWMUsmKmiQcRZnOuJb71hPZfpbc/yazbQDFLov162mL0uBhM27mpBXQ7TH2SSC9p f3+R+0U/F4S8aiiw4xk7PSdrmwC/CMRJ2Pl+ephrB/I84wlZ+QzuWofOuvlkJoPKu4Ke 3a+Lj7mY+59tBILZgsIWD9/A3SSeB0Fs1n7p4lAkXiYG6f1FdkAJhPVz/AdV/84Wn9W/ iZ/7cV+rfD4G7wGDrUa9GKQADAQ6hT1+FYLK/eC6ODN7LYJKGCn6OS0JH6XxLyxHSILL rJgwc1bxY/Jj8eYHYXQGXRsafrbo2xwjivYWbCRmjpKGW2/Z/P4zaq95ai4GsbsgXcXY w3MA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=E3XXLHr/nGmA5/V4/eOPbUixmdbxY4k/strH8RFSBe4=; fh=+rVPbkeGqWiIgFIO/frpwDjTX43rPDo8YqRatcM7aGc=; b=LcrC9Fg0xe7ux7iZZQI8t+DE/VhsvllT4EimDekXv74ydp9H57PrE01ybU0LxsK4Jf WbGNxu0ysuQ10kGskj4t/ff1PbjyK5d9Sf5/Pfv23kqcwxstQ9xk/XPONrjM24CAx5NI /gpIE6QaN2DIOh8zD0F1BNJb+Wy8JGFrBqRzMREChAvASmixRcwaYe0Q0FSj0msgBktz Q9S/beiiU2i7Br4+s2cQ5QcY8ePmWT4OW1LXTUPjkx81ABISEYgpxxXCoMCXgI0D4Prg QkNKLY1a5ffB7Fd+NtBTcEWRem7cvQG1LdmOxE2dcalde8gU7aExrt+JkPdfZiZb8j8E WGxg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776691832; x=1777296632; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=E3XXLHr/nGmA5/V4/eOPbUixmdbxY4k/strH8RFSBe4=; b=egbjN5U35Vf8Frm1PtM8afw2eDDdfkqU48nObGasAGZwm4OjrTJUubTXmDnwhAkbkS y82z64iXC7KD9tuPmzuke4tcVdReDhKYpqEbRA28257HjGBz+im3Rpko1xQEa8xAff9o kAL1amHzr7LfY+JfVhHaGoh3+ewTlISPaagPAVikV3Di26N5KTzZLqGcrmhxNx9JV39N 9vfbZIeqFFUfuT4jMtDxqavccEpctugrzAIeeOCXVV+lwlK/NtuzCIwv/fWlCMiZgFyu w9PdRWI/qjPH9YABKoejVPC5sBaNmZe8eggAnb188XirXQRjDFJfjmxy0iRVQnjKbRz8 AYFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776691832; x=1777296632; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=E3XXLHr/nGmA5/V4/eOPbUixmdbxY4k/strH8RFSBe4=; b=APOs0HwlsIx0HOwgC3CuhxtA+KtPAlYmvNCIEZ7ICynfwfpaB6xtvRGPq9SpqusqCi RK7psx2YuC1r/uAQDRpgXBnjsH7Rj5luaXTH5HSNUEO4UVfSkcvWukWBEr2mm/vahuSP ud/DBFVOnxi/J2hUVBMDid4AaRT3V7tdYj78II+hBbAb458H5fEeeYXyV10BH17DueHT 3TH02HoggK8IcVzpACbB2dLrpInHl3eNwX6ngOKT6xK+pebaFQdHOV0Mm6nn5SwTTZqV aLuk54vUkjIqjTkMV8LMA15ovUYT0O23S3FtVrhZs6KWs+PmrdTo+FMphh0S+DLH9rMH cLHg== X-Gm-Message-State: AOJu0Yzz3pduHGmhBuWZODnAZ4o/sGIYigC2Jat1IXSNAdWD2OUtxV6/ QKSAOP+0k+Ooap+FN3ytq8uSJCFwj4o5HCkMzjS7UHHPGQsimrJso9ohRi0aFYdguHugqBcnloG BFUnoHasG1ZXeXxS1ERQuoaFAYFZKGFI= X-Gm-Gg: AeBDiet+JKNheJ17sybkUbwwPSvN/trv0kOrvAIKKkTuH+6byJ8Fs79oRqU84LNSxgl WP/nSG+Mv+qqhng02ALBKJQkIcJCzpSu1kksRdVaM7J/OEmXhHMsQfrWn5ej3MILb4cpDABN+Fc 1YHygjjS7VLXIOGxcx0t08HG34KfQIr5+arGuLkLwXVfRyc9bS/ark2UWtsbhU02vSmnmKJfdCU 0olgCGYX45e0T8nDZdVjwXZNLNPuqbT0qnvOmwJfdbDtZM6WqHH9RFm1TYsTSXwpds/uB6IvsjT Mzv2fJFx0nL44HY3MzyGICDlkpuasJYqlNRMF5MOpMdLTFQeiA== X-Received: by 2002:a05:6820:99b:b0:68b:6c1d:2258 with SMTP id 006d021491bc7-69462eb9a9fmr6925466eaf.31.1776691831984; Mon, 20 Apr 2026 06:30:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Mon, 20 Apr 2026 09:29:56 -0400 X-Gm-Features: AQROBzC8Qq0GSeBXca_HmNIa1wakqBor3F8bicjaaMk4Sa2DUQdh-RdyQ70XBNY Message-ID: Subject: Re: Test cluster with high OIDs above the signed-int limit (2B+) To: Dominique Devienne Cc: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="00000000000085581b064fe44dc5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000085581b064fe44dc5 Content-Type: text/plain; charset="UTF-8" You can change the define for FirstNomalObjectId in include/access/transam.h to a very large number and recompile Postgres. I don't know an easy way to increment that for an existing cluster other than creating/removing an object in a client loop. --00000000000085581b064fe44dc5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
You can change the define for FirstNomalObjectId in=C2=A0i= nclude/access/transam.h to a very large number and recompile Postgres.
=
I don't know an easy way to increment that for an existi= ng cluster other than creating/removing an object in a client loop.


--00000000000085581b064fe44dc5--