M4N - Dennis Brouwer <dennis.brouwer@m4n.nl> writes:
> We are trying to recover this database on a different server and
> re-indexed all (but one) tables, only one -unimportant- table refuses to
> be re-indexed or even dropped. We desperately want to drop this single
> table (it's recreated constantly) but we can not, the following message
> is given:
> DROP TABLE statistics_sliding_per_merchant;
> ERROR: 1 constraint record(s) missing for rel
> statistics_sliding_per_merchant
You should be able to deal with that by manually updating
pg_class.relchecks for the table, so that it matches the number of check
constraints actually present.
regards, tom lane