pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sean Hamilton <sehamilt@chfund.org>
To: Lynna Landstreet <lynna@spidersilk.net>
To: pgsql-php@postgresql.org
Subject: Re: Trapping PostgreSQL error messages
Date: Wed, 11 Jan 2006 16:23:41 -0500
Message-ID: <43C5775D.9080608@chfund.org> (raw)
In-Reply-To: <BFEADCA4.23CEB%lynna@spidersilk.net>
References: <BFEADCA4.23CEB%lynna@spidersilk.net>

Check out your php.ini file.  See the section on error handling.
change:
display_erros =  Off
log_errors = On

-Sean

Lynna Landstreet wrote:

>Hi there,
>
>This may be a really basic question to those who have more programming
>experience than I do, but I was wondering if there's any good way to trap
>PostgreSQL error messages so that they're logged to a file, but a site user
>doesn't see them and gets a more user-friendly error message instead.
>
>I have a few standard things in there like "or die" with a custom error
>message in brackets after pg_query statements, but what that seems to
>generate is the regular messy PostgreSQL error messages *plus* whatever I
>put in for the die message, rather than my message being displayed *instead*
>of the ones the server generates. Is there a way of changing this so that I
>can provide a friendlier error message and keep the more detailed ones
>logged somewhere for my own viewing?
>
>Searching the web, I did find this:
>http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.htm
>l#PLPGSQL-ERROR-TRAPPING
>But found it a bit confusing, probably because I'm not all that certain what
>PL/pgSQL is, or if/how you could apply this in practice on a PHP-based site.
>Could the exception statements they're using there be used to generate
>custom error messages? Would the original PostgreSQL error message with all
>detail still be recorded somewhere?
>
>Is there a more detailed (and/or comprehensible to a not-so-experienced
>programmer) explanation of this somewhere?
>
>
>Lynna
>
>  
>




view thread (2+ messages)

Message-ID: <43C5775D.9080608@chfund.org>
Permalink:  ../43C5775D.9080608@chfund.org/
Also on:    postgresql.org/message-id/43C5775D.9080608@chfund.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: sehamilt@chfund.org, lynna@spidersilk.net
  Subject: Re: Trapping PostgreSQL error messages
  In-Reply-To: <43C5775D.9080608@chfund.org>
  References: <BFEADCA4.23CEB%lynna@spidersilk.net> <43C5775D.9080608@chfund.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox