Re: Backend message type 0x44 arrived while idle

I can actually select just one row as

select * from table limit 1 offset 270
(anything below 270 is fine)

and the same error pops up. It have heaps of memory available..

Jason

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tsukaeru.net Webmaster" <webmaster(at)tsukaeru(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, August 24, 2001 12:31 PM
Subject: Re: [GENERAL] Backend message type 0x44 arrived while idle

> "Tsukaeru.net Webmaster" <webmaster(at)tsukaeru(dot)net> writes:
> > My database is giving me trouble. I assume that it is due to a bad
record,
> > but I am unable to select/delete that record. Have checked logs with no
> > helpful info.
>
> The problem could be at the client side, eg libpq running out of memory.
> (Its recovery from this problem is pretty abysmal at the moment :-(.)
> Are you selecting a whole lot of data in this query?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>