Re: Backend sent D message without prior T - Mailing list pgsql-general

From Tom Lane
Subject Re: Backend sent D message without prior T
Date
Msg-id 13803.982165422@sss.pgh.pa.us
Whole thread Raw
In response to Backend sent D message without prior T  (Antonis Antoniou <a.antoniou@albourne.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Antonis Antoniou
Date:
Subject: Backend sent D message without prior T
Next
From: Holger Klawitter
Date:
Subject: Re: very simple: How can I multiply tables?