Re: Problem while reading from some tables - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Problem while reading from some tables
Date
Msg-id Pine.BSF.4.21.0105180907380.42896-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Problem while reading from some tables  ("Davide" <floods@libero.it>)
List 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@postgresql.org)
>


pgsql-general by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: debian packages for Postgresql 7.1 or higher ?
Next
From: Stephan Szabo
Date:
Subject: Re: Foreign key constraint generates unique index?