Re: PostgreSQL 8.1.0 catalog corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bob Ippolito <bob(at)redivi(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1.0 catalog corruption
Date: 2005-11-21 21:14:48
Message-ID: 4193.1132607688@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bob Ippolito <bob(at)redivi(dot)com> writes:
> On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:
>> Try dropping the type.

> I did try that, I guess it didn't make it to the list yet:

> mochi=# drop type ping_1132387200;
> ERROR: cache lookup failed for relation 211174567

Hmm, apparently there are still entries in pg_depend for these objects.
Would you look to see what is in pg_depend with either objid or refobjid
equal to either 211174567 or the type's oid (possibly 211174568, but
check)?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bob Ippolito 2005-11-21 21:26:06 Re: PostgreSQL 8.1.0 catalog corruption
Previous Message Qingqing Zhou 2005-11-21 21:07:43 Re: [ADMIN] ERROR: could not read block