MIME-Version: 1.0
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <58221272-d684-4799-a113-d5a5031a0b05@aklaver.com> <AS2PR05MB107541E760AECB8639BB968B5EF63A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <fd548bde-54d3-426a-a2b6-058750cfb554@aklaver.com> <AS2PR05MB1075432E74AF2FA975B02519AEF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <b1fec029-b8fb-4177-a01a-9457e813ce68@aklaver.com> <AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <25b5291f-a3d3-4655-a3d3-57f28b70ec5a@aklaver.com> <AS2PR05MB107546C1B04FC4B3CCF32E60CEF7DA@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <78328b08-249e-4251-8a10-b5dac183442a@aklaver.com> <DB5PR05MB107646FFE78759D1D5431F802EF7AA@DB5PR05MB10764.eurprd05.prod.outlook.com>
 <0868c260-9812-4629-b32d-026c1fe6089f@aklaver.com> <AS2PR05MB1075476F648651C8CC02D8048EF79A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <CAKAnmmLsxdt51sp-w0JxMi0haGXHFKD2pXURfOSOa5iVzjni4w@mail.gmail.com> <7d455186-0cba-4fd5-9f9e-7051627b3ae3@aklaver.com>
In-Reply-To: <7d455186-0cba-4fd5-9f9e-7051627b3ae3@aklaver.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 9 Mar 2026 13:53:39 -0400
Message-ID: <CAKAnmmJzw9TeOd=_VtJ430_AhS+asfRLuOg=mgL0yT_K+7X-yQ@mail.gmail.com>
Subject: Re: Index (primary key) corrupt?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Wim Rouquart <wim.rouquart@kbc.be>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004cdc1e064c9b1789"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJzw9TeOd%3D_VtJ430_AhS%2BasfRLuOg%3DmgL0yT_K%2B7X-yQ%40mail.gmail.com>
Precedence: bulk

--0000000000004cdc1e064c9b1789
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 9, 2026 at 11:37=E2=80=AFAM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> This post in answer:
>
>
> https://www.postgresql.org/message-id/AS2PR05MB107549DDE42DC0B8E31CB52BFE=
F90A%40AS2PR05MB10754.eurprd05.prod.outlook.com
>
> would seem to indicate that is not the issue.
>

Ah, but those are doing the lookup by the index (via indexrelid) but I am
curious about looking up by the table (indrelid), as that is how pg_dump is
going to get at it.

Cheers,
Greg

--0000000000004cdc1e064c9b1789
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Mar 9, 2026 at 11:37=E2=80=AFAM A=
drian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_cont=
ainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex">This post in answe=
r:<br>
<br>
<a href=3D"https://www.postgresql.org/message-id/AS2PR05MB107549DDE42DC0B8E=
31CB52BFEF90A%40AS2PR05MB10754.eurprd05.prod.outlook.com" rel=3D"noreferrer=
" target=3D"_blank">https://www.postgresql.org/message-id/AS2PR05MB107549DD=
E42DC0B8E31CB52BFEF90A%40AS2PR05MB10754.eurprd05.prod.outlook.com</a><br>
<br>
would seem to indicate that is not the issue.<br></blockquote><div><br></di=
v><div>Ah, but those are doing the lookup by the index (via indexrelid) but=
 I am curious about looking up by the table (indrelid), as that is how pg_d=
ump is going to get at it.</div><div>=C2=A0</div></div><div dir=3D"ltr" cla=
ss=3D"gmail_signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><d=
iv><br></div><div><br></div></div></div></div>

--0000000000004cdc1e064c9b1789--