Thread: Problem with sql

Problem with sql

From

"De Leeuw Guy"

Date:

16 April 2003, 08:54:38

Hello everybody,

I running Postgres on a AIX 4.3.3 system, and have encountered an error
to be a communication problem between the backend and the frontend when
making a query on a approximately 66Mb return result.
The error returned is :
"Backend Sent D message without Prior T"

With about 31 Mb no problems !

It is a congiguration options ?

Thanks in advance,

Guy

Re: Problem with sql

From

Tom Lane

Date:

16 April 2003, 13:37:51

"De Leeuw Guy" <G.De_Leeuw@eurofer.be> writes:
> I running Postgres on a AIX 4.3.3 system, and have encountered an error
> to be a communication problem between the backend and the frontend when
> making a query on a approximately 66Mb return result.
> The error returned is :
> "Backend Sent D message without Prior T"

libpq is running out of memory to store the query result.  It does not
handle that very gracefully :-(

            regards, tom lane