Re: Backend sent D message without prior T

Tom Lane wrote:

> Antonis Antoniou <a.antoniou@albourne.com> writes:
> > I get the following message:
> > Backend sent D message without prior T
>
> > Does anyone knows about this message? I am expecting to retrieve
> > 2818510  records and am using  PostgreSQL 7.1beta4.
>
> IIRC, this is a fairly common symptom of the frontend app running out
> of memory --- libpq loses sync with what the backend is sending, and
> it doesn't handle that very gracefully.
>
> I'd suggest using a cursor to retrieve the data in more manageable
> chunks.
>
>                         regards, tom lane

This is strange because the machine has 1GB of memory.  Using the same
database on PostgreSQL 7.0.2  and on a machine that has 500MB of memory
the above query works fine.

    Regards
         Antonis