On Mon, 5 Aug 2002, Jakub Ouhrabka wrote:
>
> > >i think it's your client (psql) what's actually crashing. it's attempting
> >
> > Yes it is. But without using a cursor (and even if this kind of query isn't
> > recommended) is there any solution to limit the use of the memory by PG itself
> > (as for Oracle) ?
>
What sort of error does Oracle report when you try to retrieve several GB of
data? Is this in it's 'command line' interface?
Basically what I'm asking about is what the Client/Server protocol does.
Presuming that all clients don't crash but abort the query then presumably the
client library is doing the abort when it fails to allocate a chunk of storage
during the recieve. I must admit to not knowing what libpq does but it
certainly doesn't trap this situation and return an error to the caller. Why
not? Other than the caller should be implementing sufficient intelligence in a
real application to avoid the situation.
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants