"could not open file" issue

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: "could not open file" issue
Date: 2006-04-24 16:17:07
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D20213249A@UBIMAIL1.ubisoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Is there any way to solve the following issue without dropping the
table?

select count(*) from eventplayerleaveroom;
ERROR: could not access status of transaction 3164404766
DETAIL: could not open file "pg_clog/0BC9": No such file or directory

Regards,

P.S.: PostgreSQL server 8.1.3

--
Daniel CAUNE
Ubisoft Online Technology
(514) 4090 2040 ext. 5418

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2006-04-24 19:02:02 Re: "could not open file" issue
Previous Message Markus Schaber 2006-04-24 11:34:33 Re: Migrating a Database to a new tablespace