Ok, have tried this in debug mode and the log shows....
010825.20:54:27.635 [8851] StartTransactionCommand
010825.20:54:27.635 [8851] query: select * from users;
010825.20:54:27.645 [8851] ProcessQuery
Server process (pid 8851) exited with status 11 at Sat Aug 25 20:54:27 2001
Terminating any active server processes...
Server processes were terminated at Sat Aug 25 20:54:27 2001
Reinitializing shared memory and semaphores
010825.20:54:27.885 [8873] DEBUG: Data Base System is starting up at Sat
Aug 25 20:54:27 2001
Does this help at all?
Regards,
Jason Frisch
----- Original Message -----
From: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, August 24, 2001 12:58 PM
Subject: Re: [GENERAL] 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@sss.pgh.pa.us>
> To: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
> Cc: <pgsql-general@postgresql.org>
> Sent: Friday, August 24, 2001 12:31 PM
> Subject: Re: [GENERAL] Backend message type 0x44 arrived while idle
>
>
> > "Tsukaeru.net Webmaster" <webmaster@tsukaeru.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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>