Postgres Pro
Downloads
Home   >   mailing lists

"could not open file" issue - Mailing list pgsql-sql

From Daniel Caune
Subject "could not open file" issue
Date
Msg-id 1E293D3FF63A3740B10AD5AAD88535D20213249A@UBIMAIL1.ubisoft.org
Whole thread Raw
Responses Re: "could not open file" issue  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: "could not open file" issue  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
Tree view 
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
notopen 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

pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Migrating a Database to a new tablespace
Next
From: Markus Schaber
Date:
Subject: Re: Migrating a Database to a new tablespace