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