vacuumdb fails with error pg_statistic_relid_att_inh_index constraint violation after upgrade to 9.6
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
Re: vacuumdb fails with error pg_statistic_relid_att_inh_index constraint violation after upgrade to 9.6
Hello, Thanks for the reply. We deleted those rows and re run vacuum and analyze and it worked fine. Thanks, Thanks, Swapnil Vaze
