Re: PostgreSQL 8.1.0 catalog corruption

On Nov 21, 2005, at 1:14 PM, Tom Lane wrote:

> 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)?

I don't know how to get the oid of a type.. but there are certainly
entries in pg_depend with the other criteria:

mochi=# select * from pg_depend where objid=211174567;
classid | objid | objsubid | refclassid | refobjid | refobjsubid
| deptype
---------+-----------+----------+------------+-----------
+-------------+---------
1259 | 211174567 | 0 | 2615 | 2200 |
0 | n
1259 | 211174567 | 0 | 1259 | 103327322 |
0 | n
(2 rows)

mochi=# select * from pg_depend where refobjid=211174567;
classid | objid | objsubid | refclassid | refobjid | refobjsubid
| deptype
---------+-----------+----------+------------+-----------
+-------------+---------
2606 | 212119648 | 0 | 1259 | 211174567 |
1 | a
2606 | 212119648 | 0 | 1259 | 211174567 |
1 | n
2606 | 212119649 | 0 | 1259 | 211174567 |
2 | a
2606 | 212119649 | 0 | 1259 | 211174567 |
2 | n
1247 | 211174568 | 0 | 1259 | 211174567 |
0 | i
2604 | 211174569 | 0 | 1259 | 211174567 |
1 | a
1259 | 211174570 | 0 | 1259 | 211174567 |
0 | i
2606 | 211174574 | 0 | 1259 | 211174567 |
1 | a
1259 | 211174575 | 0 | 1259 | 211174567 |
2 | a
1259 | 211174576 | 0 | 1259 | 211174567 |
4 | a
1259 | 211174576 | 0 | 1259 | 211174567 |
2 | a
1259 | 211174577 | 0 | 1259 | 211174567 |
4 | a
1259 | 211174577 | 0 | 1259 | 211174567 |
7 | a
1259 | 211174577 | 0 | 1259 | 211174567 |
2 | a
1259 | 211174578 | 0 | 1259 | 211174567 |
4 | a
1259 | 211174578 | 0 | 1259 | 211174567 |
8 | a
1259 | 211174578 | 0 | 1259 | 211174567 |
2 | a
(17 rows)

-bob