From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump problem |
Date: | 2007-11-14 19:21:03 |
Message-ID: | 11581.1195068063@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> writes:
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID 670741 not found
> What causes this problem?
Corrupt system tables, looks like :-( What PG version is this?
I would suggest checking to see if either of those OIDs appears in
either the objid or refobjid columns of pg_depend. If not, the
most likely theory is that this pg_rewrite entry somehow didn't
get deleted when its parent table was dropped. You could just
delete it manually, eg,
delete from pg_rewrite where oid = 670741;
If you do find other traces of the table it might be better to try
to resurrect the table (actually it's most likely a view not a
table).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | SHARMILA JOTHIRAJAH | 2007-11-14 19:24:23 | Re: pg_dump problem |
Previous Message | Joshua D. Drake | 2007-11-14 19:13:40 | Re: PLpgsql debugger question |