Postgres Pro
Downloads
Home   >   mailing lists

vacuumdb fails with error pg_statistic_relid_att_inh_index constraintviolation after upgrade to 9.6 - Mailing list pgsql-general

From Swapnil Vaze
Subject vacuumdb fails with error pg_statistic_relid_att_inh_index constraintviolation after upgrade to 9.6
Date
Msg-id CABWf+yTFyZFgnuaLz1OVYdWMOPkeEH6BkvXGoTgBRuUqbS0SVw@mail.gmail.com
Whole thread Raw
Responses Re: vacuumdb fails with error pg_statistic_relid_att_inh_index constraint violation after upgrade to 9.6  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hello, We have upgraded our database from 9.5 to 9.6 version. After upgrade we ran vacuumdb command and we are getting following error: vacuumdb: vacuuming of database "advdfat" failed: ERROR: duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" DETAIL: Key (starelid, staattnum, stainherit)=(1259, 1, f) already exists. Can anyone help here? -- Thanks & Regards, Swapnil Vaze

pgsql-general by date:

Previous
From: VENKTESH GUTTEDAR
Date:
Subject: [GENERAL] - Regarding Schema ROLLBACK
Next
From: Robert Haas
Date:
Subject: Re: ERROR: too many dynamic shared memory segments