| Patrick.FICHE@AQSACOM.COM 2005-05-23, 11:23 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|