M4N - Dennis Brouwer <dennis.brouwer@xxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
