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 : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane Sent: lundi 23 mai 2005 16:50 To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to recover from : "Cache lookup failed for rela tion " [EMAIL PROTECTED] 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
