Re: "could not open file" issue

Daniel Caune wrote:
> 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

Are the files in pg_clog close to the vicinity of 0BC9?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.