Re: out of memory error - Mailing list pgsql-general

From Geoffrey Myers
Subject Re: out of memory error
Date
Msg-id 4E1329DD.9010408@serioustechnology.com
Whole thread Raw
In response to Re: out of memory error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: out of memory error  (Craig Ringer <craig@postnewspapers.com.au>)
Re: out of memory error  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
List pgsql-general
Tom Lane wrote:
> Geoffrey Myers <geof@serioustechnology.com> writes:
>> Geoffrey Myers wrote:
>>> out of memory for query result
>
>> One other note that is bothering me.  There is no reference in the log
>> regarding the out of memory error.  Should that not also show up in the
>> associated database log?
>
> Not if it's a client-side error.
>
> (Which a quick grep through the PG source code says it is ...)
>
>             regards, tom lane

Wanted to add more specifics. Here is the actual code that generated the
error:

my $result = $conn->exec($select);

if ($result->resultStatus != PGRES_TUPLES_OK)
{
    $error = $conn->errorMessage;
         die "Error: <$error> Failed: <$select>";
}

So you're saying this select request failing would not be logged to the
postgres database log?


--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: out of memory error
Next
From: Tom Lane
Date:
Subject: Re: Select count(*) /*from*/ table