Re: Cache lookup failure for pg_restore?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: surdules(at)yahoo(dot)com (Razvan Surdulescu)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cache lookup failure for pg_restore?
Date: 2004-05-05 18:09:52
Message-ID: 8373.1083780592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

surdules(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2004-05-05 18:12:37 Re: Embedded SQL inherently faster than others?
Previous Message Uwe C. Schroeder 2004-05-05 18:00:06 Re: Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird