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

Поиск

Список

Период

Сортировка

От	Raghavendra Rao J S V
Тема	duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"while performing full vacuum on the database
Дата	9 мая 2018 г. 13:31:54
Msg-id	CAEHH7R5+HRWpOsz99-WQNGPR7NH-AELV5Q63WtWnb38MM9tG9w@mail.gmail.com обсуждение исходный текст
Ответы	Re: duplicate key value violates unique constraint"pg_statistic_relid_att_inh_index" while performing full vacuum on thedatabase (Laurenz Albe <laurenz.albe@cybertec.at>)
Список	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

В списке pgsql-general по дате отправления:

От: tango ward
Дата: 09 мая 2018 г., 10:43:01
Сообщение: Re: Concatenate 2 Column Values For One Column

От: John McKown
Дата: 09 мая 2018 г., 13:59:34
Сообщение: Enhancement to psql command, feedback.