Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id ED8C19FC41E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 25 Oct 2007 05:26:37 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 28735-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 25 Oct 2007 05:26:21 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from web51004.mail.re2.yahoo.com (web51004.mail.re2.yahoo.com
	[206.190.38.135])
	by postgresql.org (Postfix) with SMTP id 8036A9FC22E
	for <pgsql-sql@postgresql.org>; Thu, 25 Oct 2007 05:26:24 -0300 (ADT)
Received: (qmail 82249 invoked by uid 60001); 25 Oct 2007 08:26:22 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=LHOnoIe0jh7RPl9ktK3SpBlxXXSJf5x4FwMkUvaiDt9qneMFM/SvyuKYaI7aL6MUPRcg/0zeH2RPRb4C1gLZMjdQ6PWJSi/1gnaJHlWCucW6td4AWPfYnuEvuHM1TxAakdBUskM5A5ITLi8C8Bwxld9r9Rzh9XuEuj6LK6dgQnE=;
X-YMail-OSG: 
 NjDT5oMVM1lrjzfYvfTqF5fpT.vk4oszwM02_FIzt_xQ0shWH6uZwpNeYVqVgz1hivYHPPb7oNl37Sbo9_37KEvvZjx_zJ6VXCQ9qxbXRl9t8HH0aBQ-
Received: from [222.124.227.109] by web51004.mail.re2.yahoo.com via HTTP;
	Thu, 25 Oct 2007 01:26:22 PDT
Date: Thu, 25 Oct 2007 01:26:22 -0700 (PDT)
From: Otniel Michael <otmic_ie@yahoo.com>
Subject: Re: ERROR: failed to re-find parent key in "pk_ep07" 
To: Community PostgreSQL <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="0-852407347-1193300782=:77492"
Content-Transfer-Encoding: 8bit
Message-ID: <782676.77492.qm@web51004.mail.re2.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/113
X-Sequence-Number: 29485

--0-852407347-1193300782=:77492
Content-Type: multipart/alternative; boundary="0-974920306-1193300782=:77492"

--0-974920306-1193300782=:77492
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit



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 
--0-974920306-1193300782=:77492
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<br><br>Note: forwarded message attached.<BR><BR><div style="text-align: center;"><span style="color: rgb(0, 128, 255); font-style: italic;">-- </span><br style="color: rgb(0, 128, 255); font-style: italic;"> <span style="color: rgb(0, 128, 255); font-style: italic;">"He who is quick to become angry will commit folly, and a crafty man is hated" </span><br> </div><p>&#32;__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-974920306-1193300782=:77492--

--0-852407347-1193300782=:77492
Content-Type: message/rfc822
Content-Transfer-Encoding: 8bit

Received: from [222.124.227.109] by web51009.mail.re2.yahoo.com via HTTP;
	Wed, 24 Oct 2007 22:36:49 PDT
Date: Wed, 24 Oct 2007 22:36:49 -0700 (PDT)
From: Otniel Michael <otmic_ie@yahoo.com>
Subject: Re: [SQL] ERROR: failed to re-find parent key in "pk_ep07" 
To: Tom Lane <tgl@sss.pgh.pa.us>
In-Reply-To: <6415.1193287511@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1079622018-1193290609=:71383"
Content-Transfer-Encoding: 8bit
Content-Length: 918

--0-1079622018-1193290609=:71383
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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@sss.pgh.pa.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 
--0-1079622018-1193290609=:71383
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<span style="color: rgb(64, 64, 255);">OC. I will try to upgrade the postgres. What version that can fix this problem? Postgres 8.2.5? Postgres 8.1?<br><br>Now, i use postgres 8.0.3, what effect when i upgrade the postgres version?<br>I heared that i should check my sql? In postgres 8.0.3 show as warning, in postgres 8.1 as error?<br><br>Thanks.<br></span><br><b><i>Tom Lane &lt;tgl@sss.pgh.pa.us&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Otniel Michael <otmic_ie@yahoo.com> writes:<br>&gt; When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this?<br>&gt;            ERROR:  failed to re-find parent key in "pk_ep07"<br><br>Update to a newer PG version, possibly?  This symptom has been seen<br>before...<br><br>   regards, tom lane<br></otmic_ie@yahoo.com></blockquote><br><BR><BR><div style="text-align: center;"><span style="color: rgb(0, 128,
 255); font-style: italic;">-- </span><br style="color: rgb(0, 128, 255); font-style: italic;"> <span style="color: rgb(0, 128, 255); font-style: italic;">"He who is quick to become angry will commit folly, and a crafty man is hated" </span><br> </div><p>&#32;__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-1079622018-1193290609=:71383--

--0-852407347-1193300782=:77492--