Re: Cache lookup failure for pg_restore? - Mailing list pgsql-general

From Tom Lane
Subject Re: Cache lookup failure for pg_restore?
Date
Msg-id 8373.1083780592@sss.pgh.pa.us
Whole thread Raw
In response to Cache lookup failure for pg_restore?  (surdules@yahoo.com (Razvan Surdulescu))
Responses Re: Cache lookup failure for pg_restore?  (Razvan Surdulescu <surdules@yahoo.com>)
List pgsql-general
surdules@yahoo.com (Razvan Surdulescu) writes:
> cspan=> update contact set gender = 'M';
> ERROR:  cache lookup failed for function 70529

> If I re-run the update, I get:

> cspan=> update contact set gender = 'M';
> server closed the connection unexpectedly

Hm, could we see the full schema for the "contact" table?

> The database has a few GIST (full-search, tsearch2) indices, but
> otherwise is pretty ordinary.

Any of those on "contact"?

What would be useful to look at is a debugger stack trace from the core
dump...

Also it might be worth your time to update to 7.4.2, just to see if this
is an already-fixed bug.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Embedded SQL inherently faster than others?
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird