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:
Show quoted text
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 potatoThank 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