From: | "Nykolyn, Andrew" <andrew(dot)nykolyn(at)ngc(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Corrupt catalog |
Date: | 2005-09-16 18:17:32 |
Message-ID: | 6F4D9B093B96EB49BE874536152F4B3B064B0D@xcgny106.northgrum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
In trying to determine why I had a corrupted piece of data (still
investigating that) I created a temporary table that contained the row
of data in question. In doing so, I must have done something to the
pg_catalog because I no longer was able to perform a dump without
getting the following error:
pg_dump: schema with OID 469554554 does not exist
I recycled the server. I cannot see the temporary table anywhere as
(expected) through psql or PG Admin. However, looking at the pg catalog
I found the above OID referenced in the tables in the attached
spreadsheet with the name of the temporary table that I created. My
database is functioning without problem. However, I cannot perform a
database dump. Please advise on how I can correct this problem. I am
working in a PosgteSQL 7.4.2 database on a Red Hat Linux 8.0 OS.
With Great Thanks,
Andy Nykolyn
Northrop Grumman
<<catalog_data.xls>>
Attachment | Content-Type | Size |
---|---|---|
catalog_data.xls | application/vnd.ms-excel | 23.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2005-09-16 18:26:11 | Re: when started century? PostgreSQL vs Oracle diff |
Previous Message | Marc G. Fournier | 2005-09-16 18:13:44 | Beta2 Bundled ... |