From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | M4N - Dennis Brouwer <dennis(dot)brouwer(at)m4n(dot)nl> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database recovery due to out of disk space |
Date: | 2009-10-01 16:10:14 |
Message-ID: | 20284.1254413414@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Flavio Henrique Araque Gurgel | 2009-10-01 16:50:42 | Re.: Database recovery due to out of disk space |
Previous Message | Tom Lane | 2009-10-01 14:34:37 | Re: Seek info on 7.4.23 server/8.1.1 psql compatibility issues. |