Re: Database recovery due to out of disk space

M4N - Dennis Brouwer <dennis(dot)brouwer(at)m4n(dot)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