Re: Error message : Server sent data ("D" message) ....

On Wed, Jun 26, 2002 at 10:16:24PM +0200, Jean-Michel Chabanne wrote:
>
> Hi,
>
> Today I got this message :
>
> server sent data ("D" message) without prior row description ("T" message)
>
> The query was a single select on a single table (a little more than 1.5
> millions rows) :
>
> select * from nom_table;

I think the client got confused. What is happening is that the server is
sending the entire table to the client side and the client is storing the
whole thing in memory. Can you even store that?

> The message appeared a lot of times, and the query returned nothing. I had
> to kill the postgres subprocess which appeared in IDLE state.
>
> I run PostgreSQL 7.2.1 under AIX 4.3.3.
>
> >From others psql clients, it was possible to run queries on this table.
>
> What do these messages mean ?

It's a client error. Don't do select * on a big table, only bad things
happen.

Maybe you want cursors?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.