Home > mailing lists

duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"while performing full vacuum on the database - Mailing list pgsql-general

From	Raghavendra Rao J S V
Subject	duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"while performing full vacuum on the database
Date	May 9, 2018 10:31:54
Msg-id	CAEHH7R5+HRWpOsz99-WQNGPR7NH-AELV5Q63WtWnb38MM9tG9w@mail.gmail.com Whole thread Raw
Responses	Re: duplicate key value violates unique constraint"pg_statistic_relid_att_inh_index" while performing full vacuum on thedatabase
List	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

From: tango ward
Date: 09 May 2018, 07:43:01
Subject: Re: Concatenate 2 Column Values For One Column

From: John McKown
Date: 09 May 2018, 10:59:34
Subject: Enhancement to psql command, feedback.