Thanks for the help. Do you have any idea on the reason of this situation ? Is there any information I can provide if the problem happens again to help find the problem : any log level to raise ? Patrick ---------------------------------------------------------------------------- --------------- Patrick Fiche email : patrick.fiche@xxxxxxxxxxx tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Tom Lane Sent: lundi 23 mai 2005 16:50 To: Patrick.FICHE@xxxxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: How to recover from : "Cache lookup failed for rela tion " Patrick.FICHE@xxxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
