Re: ERROR: failed to re-find parent key in "pk_ep07"

[Otniel Michael <otmic_ie(at)yahoo(dot)com>]

Note: forwarded message attached.

--
"He who is quick to become angry will commit folly, and a crafty man is hated"

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--- Begin Message ---

• From: Otniel Michael <otmic_ie(at)yahoo(dot)com>
• To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
• Subject: Re: [SQL] ERROR: failed to re-find parent key in "pk_ep07"
• Date: Wed, 24 Oct 2007 22:36:49 -0700 (PDT)

OC. I will try to upgrade the postgres. What version that can fix this problem? Postgres 8.2.5? Postgres 8.1?

Now, i use postgres 8.0.3, what effect when i upgrade the postgres version?
I heared that i should check my sql? In postgres 8.0.3 show as warning, in postgres 8.1 as error?

Thanks.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

Otniel Michael writes:
> When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this?
> ERROR: failed to re-find parent key in "pk_ep07"

Update to a newer PG version, possibly? This symptom has been seen
before...

regards, tom lane

--
"He who is quick to become angry will commit folly, and a crafty man is hated"

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--- End Message ---