Re: out of memory error on a delete command - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: out of memory error on a delete command
Date
Msg-id 42D503F7.6020008@opencloud.com
Whole thread Raw
In response to Re: out of memory error on a delete command  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: out of memory error on a delete command  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-jdbc
Dave Cramer wrote:

>>>>> org.postgresql.util.PSQLException: ERROR: out of memory
>>>>>
>>
>> is just the driver reporting a server-side error, so it's the  server
>> that's run out of memory in this case.
>
>
> If this is the case, I wonder if we can be more verbose about the
> message. Seems we can't see the forest for the trees here.

Well, we're just propagating whatever the server tells us so if you want
a better message there it needs to be changed in the backend. We do
exactly the same for all backend errors, it's just that usually it's a
more obvious message along the lines of "ERROR: syntax error near ..."
or similar.

We could add some sort of "Error reported by backend:" prefix, I
suppose, but I'm not sure if that's really useful in most cases since
most errors are self-explanatory.

Kris has suggested adding more fields from the backend's error to the
default exception message, e.g. the DETAIL field. I'm not sure if that
would add anything in this particular case though.

-O

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: out of memory error on a delete command
Next
From: Csaba Nagy
Date:
Subject: Re: out of memory error on a delete command