Re: [HACKERS] ERROR: cache lookup for proc 43030134 failed
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
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
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