| From: | terry(at)greatgulfhomes(dot)com |
|---|---|
| To: | "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | how to force drop a table |
| Date: | 2002-10-30 15:53:33 |
| Message-ID: | 014f01c2802c$8047ca20$2766f30a@development.greatgulfhomes.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I want to backup my database, which appears to be corrupt. The projects
table is corrupt:
bash$ pg_dump devtest2
pg_dump: Attempt to lock table "projects" failed. ERROR: cannot find
attribute
8 of relation projects
When I try to drop this corrupted table:
devtest2=# drop table projects;
ERROR: cannot find attribute 8 of relation projects
How can I manually purge this table from the system tables so that I can run
a backup and then recreate the database?
Thanks
Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | terry | 2002-10-30 15:56:04 | backing up corrupt database |
| Previous Message | Shridhar Daithankar | 2002-10-30 15:41:48 | Re: how to terminate a process when kill fails |