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

From Craig Ringer
Subject Re: out of memory error
Date
Msg-id 4E13A675.6070702@postnewspapers.com.au
Whole thread Raw
In response to Re: out of memory error  (Geoffrey Myers <lists@serioustechnology.com>)
List pgsql-general
On 5/07/2011 11:12 PM, Geoffrey Myers wrote:

> 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?

If that request failed due to a server-side error, then that error would
appear in the server logs.

If it failed for a client-side reason like the client running out of
memory, then at most the server would report an unexpected disconnect or
connection timeout when the client vanishes. The server has no way to
know a client process crashed out.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

pgsql-general by date:

Previous
From: "Jonathan Brinkman"
Date:
Subject: Re: Read MS-SQL data into Postgres via ODBC link?
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Read MS-SQL data into Postgres via ODBC link?