Re: out of memory error

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/