Re: How to recover from : "Cache lookup failed for rela
От | Patrick.FICHE@AQSACOM.COM |
---|---|
Тема | Re: How to recover from : "Cache lookup failed for rela |
Дата | |
Msg-id | 1DC6C8C88D09D51181A40002A5286929B23002@intranet обсуждение исходный текст |
Ответы |
Re: How to recover from : "Cache lookup failed for rela tion "
|
Список | pgsql-general |
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@aqsacom.com tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane Sent: lundi 23 mai 2005 16:50 To: Patrick.FICHE@AQSACOM.COM Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to recover from : "Cache lookup failed for rela tion " 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
В списке pgsql-general по дате отправления: