Re:

Teruel Tony wrote:
>
> Hi,
>
> The query is simple:
>
> select count(*) from table;
>
> I have the same error message  with almost all queries,
> I'm trying to debug what's new on that table (data)
> because it was working fine..
>
> The version I'm using:
>
> PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66
>
> The table:
>
> +----------------------------+----------------------------+------+
> |           Field            |           Type             |Length|
> +----------------------------+----------------------------+------+
> | dfoclave                   | int4 not null              |    4 |
> | dfoforo                    | int4 not null              |    4 |
> | dfopadre                   | int4                       |    4 |
> | dfonombre                  | varchar()                  |   80 |
> | dfotitulo                  | varchar()                  |   80 |
> | dfofecha                   | timestamp not null         |    4 |
> | dfotexto                   | text                       |  var |
> +----------------------------+----------------------------+------+
>

Just a wild shot, of course - but perhaps an index or relation
file is corrupted. Unless the table is unusually large, I don't
see how the backend could die on this one. Perhaps you could
peform a manual COPY, drop and recreate the table and its indexes
and COPY the data back in.

Hope that helps,

Mike Mascari