pg_clog/0202 Error

From: Judith Altamirano <jaltamirano(at)correolux(dot)com(dot)mx>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: pg_clog/0202 Error
Date: 2008-12-16 17:54:38
Message-ID: 4947EB5E.2070204@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello every body I just want to know why is happening this to my data
base I'm doing the following query:

SELECT * FROM pagos where date(fecha_pago) = '2008-12-15';

It returns the next error:

ERROR: can't find the transaction status 538976288
DETAIL: can't open file <<pg_clog/0202>> not exist file or directory

what supposes that I must do?, is the table damaged?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2008-12-16 20:55:42 Way to eliminate pg_dump activity from pg_stat_all ?
Previous Message Tom Lane 2008-12-16 17:16:26 Re: How can this be legal syntax