duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" while performing full vacuum on the database

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" while performing full vacuum on the database
Date: 2018-05-09 07:31:54
Message-ID: CAEHH7R5+HRWpOsz99-WQNGPR7NH-AELV5Q63WtWnb38MM9tG9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

While performing vacuum full, I have received the below highlighted error.
Please guide me how to resolve this issue.

​/opt/postgres/9.2/bin/psql -p 5433 --username=cmuser cpcm -c "*VACUUM
FULL ANALYZE*;"

ERROR: *duplicate key value violates unique constraint
"pg_statistic_relid_att_inh_index"*
DETAIL: Key (starelid, staattnum, stainherit)=(18915, 6, f) already exists.

' pg_statistic ' is a meta data table. Is it ok if I remove one duplicated
record from ' pg_statistic' table?.

--
Regards,
Raghavendra Rao J S V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John McKown 2018-05-09 07:59:34 Enhancement to psql command, feedback.
Previous Message tango ward 2018-05-09 04:43:01 Re: Concatenate 2 Column Values For One Column