6 constraint record(s) missing for rel measurement_yy14_mm01

原因：

1 执行下面语句删除了一个表的约束后

deleted from  pg_constraint where conname like 'measurement%';

2 再想加一个新的约束

alter table measurement_yy14_mm01 add check(logdate>=date'2014-01-01' and logdate<date'2014-02-01');

提示以下错误：

错误:  6 constraint record(s) missing for rel measurement_yy14_mm01
********** 错误 **********

错误: 6 constraint record(s) missing for rel measurement_yy14_mm01
SQL 状态: XX000

3 试着删除表

drop table measurement_yy14_mm01 ;

提示以下错误:

错误:  cache lookup failed for constraint 41014
********** 错误 **********

错误: cache lookup failed for constraint 41014
SQL 状态: XX000

解决方案：

转载于:https://my.oschina.net/progresQi/blog/223790