Re: Problem while reading from some tables

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Davide <floods(at)libero(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem while reading from some tables
Date: 2001-05-18 16:08:25
Message-ID: Pine.BSF.4.21.0105180907380.42896-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2001-05-18 16:11:08 Re: Who can resolve this BUG ?
Previous Message Stephan Szabo 2001-05-18 16:07:01 Re: Why index don't use with SELECT