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

After running: REINDEX TABLE pg_catalog.pg_attribute ; Le mer. 1 sept. 2021 à 17:54, FOUTE K. Jaurès a écrit : > Hello Tom, > > Thank You for your Answer. It solves the problem. > Thank you very much for your support. > > Le mer. 1 sept. 2021 à 16:46, Tom Lane a écrit : > >> =?UTF-8?Q?FOUTE_K=2

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

Hello Tom, Thank You for your Answer. It solves the problem. Thank you very much for your support. Le mer. 1 sept. 2021 à 16:46, Tom Lane a écrit : > =?UTF-8?Q?FOUTE_K=2E_Jaur=C3=A8s?= writes: > > For all table except the pg_catalo table. > > The dump on the database is not possible too. (pg_d

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

=?UTF-8?Q?FOUTE_K=2E_Jaur=C3=A8s?= writes: > For all table except the pg_catalo table. > The dump on the database is not possible too. (pg_dump: error: invalid > column numbering in table "xx") It seems that pg_attribute is messed up. If you are really lucky, it might be only a problem in pg

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

On Wed, Sep 1, 2021 at 8:29 AM FOUTE K. Jaurès wrote: > I already restart the server (x3) > > Ok. During server startup (or shutdown for that matter) are there any warnings or errors in the log file? Is there anything in the server logs from around the time this started to occur? You haven't c

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

For all table except the pg_catalo table. The dump on the database is not possible too. (pg_dump: error: invalid column numbering in table "xx") Le mer. 1 sept. 2021 à 16:27, Adrian Klaver a écrit : > On 9/1/21 8:08 AM, FOUTE K. Jaurès wrote: > > Hello, > > > > I have a strange issue in a pr

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

I already restart the server (x3) Le mer. 1 sept. 2021 à 16:25, David G. Johnston a écrit : > On Wed, Sep 1, 2021 at 8:08 AM FOUTE K. Jaurès > wrote: > >> Any idea how to solve this issue is really appreciated >> > > Have you restarted the server? > > In pg_attribute for one of the problema

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

On 9/1/21 8:08 AM, FOUTE K. Jaurès 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 To be clear t

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

On Wed, Sep 1, 2021 at 8:08 AM FOUTE K. Jaurès wrote: > Any idea how to solve this issue is really appreciated > Have you restarted the server? In pg_attribute for one of the problematic tables are all of the columns present that should be (i.e., is this a catalog contents error or, say, a

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

> On Sep 1, 2021, at 8:14 AM, FOUTE K. Jaurès wrote: > > No, I am using PostgreSQL 12 (Server and Client) > > Le mer. 1 sept. 2021 à 16:12, Rob Sargent > a écrit : > > >> On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès > > wrote: >> >

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

No, I am using PostgreSQL 12 (Server and Client) Le mer. 1 sept. 2021 à 16:12, Rob Sargent a écrit : > > > On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès 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

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

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

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

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