PostgreSQL Discussion - Re: How to recover from : "Cache lookup failed for rela tion "

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: How to recover from : "Cache lookup failed for rela tion "

Tom Lane

2005-05-23, 11:23 am

Patrick.FICHE@AQSACOM.COM writes:
> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype

> ---------+--------+----------+------------+----------+-------------+--------
> -
> 1247 | 463559 | 0 | 1259 | 463558 | 0 | i
> 1259 | 463558 | 0 | 16672 | 440012 | 0 | n
> (2 rows)

Well, what I'd recommend is to manually delete those two rows in
pg_depend and then delete the row in pg_type. This may not clean things
up 100% but it should be close enough.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links