Re: Problem while reading from some tables

"Davide" <floods@libero.it> writes:
> If a make a very simple query from the psql shell:
> nuovo_mercato=> SELECT * FROM prezzi;
> pqReadData() -- backend closed the channel unexpectedly.

Sounds like you have corrupted data in that table :-(.  Time to
restore it from a backup, I'm afraid.

> I use postgresql 6.5.3-26 on debian GNU/linux potato

Consider updating.  7.1 is much more stable than 6.5.*.

            regards, tom lane