Re: [HACKERS] ERROR: cache lookup for proc 43030134 failed

[Tom Lane]

Kovacs Zoltan <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] ERROR: cache lookup for proc 43030134 failed

[Tom Lane]

Kovacs Zoltan <[EMAIL PROTECTED]> writes:
> It means that the 21st line of the result is problematic, because writing
> 20 instead of 21 I got no problem.

I think not.  The current implementation of LIMIT fetches one more row
than is really needed, IIRC.

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [HACKERS] ERROR: cache lookup for proc 43030134 failed

[Tom Lane]

Kovacs Zoltan <[EMAIL PROTECTED]> writes:
>> I think not.  The current implementation of LIMIT fetches one more row
>> than is really needed, IIRC.

> Tom, the real problem is that I get _different_ output for 

The point is that the problem is probably in the 23rd row of pg_class,
not the 22nd.

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl