Thread: Problem while reading from some tables

If a make a very simple query from the psql shell:

nuovo_mercato=> SELECT * FROM prezzi;
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
        We have lost the connection to the backend, so further
        processing is impossible.  Terminating.

..and psql dies leaving me a bash.
My database "nuovo_mercato" contains 5 tables. 3 of them are
accessible, 2 are not. Sometimes I read something like this:

nuovo_mercato=> SELECT * FROM var_ieri;
ERROR:  var_0ieri: Table does not exist.

but I wrote "var_ieri" and not "var_0ieri"!! Of course table
"var_ieri" *does* exist!

What's happening?
I use postgresql 6.5.3-26 on debian GNU/linux potato

Thank U

I don't know of any particular bugs like that in 6.5.3, but
that version is really ancient.  I'd suggest upgrading to
7.1.x.

On Fri, 18 May 2001, Davide wrote:

> If a make a very simple query from the psql shell:
>
> nuovo_mercato=> SELECT * FROM prezzi;
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
>         We have lost the connection to the backend, so further
>         processing is impossible.  Terminating.
>
> ..and psql dies leaving me a bash.
> My database "nuovo_mercato" contains 5 tables. 3 of them are
> accessible, 2 are not. Sometimes I read something like this:
>
> nuovo_mercato=> SELECT * FROM var_ieri;
> ERROR:  var_0ieri: Table does not exist.
>
> but I wrote "var_ieri" and not "var_0ieri"!! Of course table
> "var_ieri" *does* exist!
>
> What's happening?
> I use postgresql 6.5.3-26 on debian GNU/linux potato
>
> Thank U
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

"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