Tom Lane wrote:
> Antonis Antoniou <[EMAIL PROTECTED]> 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
