Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

[Rob Sargent <robjsargent@xxxxxxxxx>]

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

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

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

On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès <jauresfoute@xxxxxxxxx> 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?