Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent - Mailing list pgsql-general

From Rob Sargent
Subject Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent
Date
Msg-id 84ED32F5-3D2D-4F48-9200-82A2711D8084@gmail.com
Whole thread Raw
In response to Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
List pgsql-general
Tree view


On Sep 1, 2021, at 8:14 AM, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:

No, I am using PostgreSQL 12 (Server and Client)

Le mer. 1 sept. 2021 à 16:12, Rob Sargent <robjsargent@gmail.com> a écrit :


On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:

Hello,

I have a strange issue in a production database on a customer and need to help to know how to solve the problem.

Any select on the table other than pg_catalog table throws the error  FATAL: catalog is missing 1 attribute(s) for 

Any idea how to solve this issue is really appreciated????


Any chance there’s a version mis-match between client and server?


from the title it looks like you have a problematic index if not a corrupted table. Can you re-index the table for that pkey?


pgsql-general by date:

Previous
From: FOUTE K. Jaurès
Date:
Subject: Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent