Re: Problem while reading from some tables

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)
>