Re: ERROR: cache lookup for proc 43030134 failed - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: cache lookup for proc 43030134 failed
Date
Msg-id 10422.991316622@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cache lookup for proc 43030134 failed  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
Responses Re: ERROR: cache lookup for proc 43030134 failed  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
Re: ERROR: cache lookup for proc 43030134 failed  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
List pgsql-hackers
Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
> Starting pg_dump, this error occured (there is no output dump,
> unfortunately). Getting closer, I got this:

> tir=# SELECT pg_get_viewdef(c.relname) AS definition FROM pg_class c
> offset 441 limit 1;
> ERROR:  cache lookup for proc 4303134 failed

I think you've got a view or rule that refers to a function you dropped.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: First version of multi-key index support for GiST
Next
From: Bruce Momjian
Date:
Subject: Re: Imperfect solutions