Problem while reading from some tables

Поиск
Список
Период
Сортировка
От Davide
Тема Problem while reading from some tables
Дата
Msg-id 9HZM6.14562$iC1.506974@news6.giganews.com
обсуждение исходный текст
Ответы Re: Problem while reading from some tables  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Problem while reading from some tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Nils Zonneveld
Дата:
Сообщение: Re: Queries across multiple databases (was: SELECT from a table in another database).
Следующее
От: Alexander Dederer
Дата:
Сообщение: Why index don't use with SELECT