Thread: error handling

hi,

im working with php 4 and postgresql 8 and i would like to know how to
handle certain errors generated. in postgresql,  i've written a stored
function that selects a record from a table and in case no record is found i
'raise an exception'. fine, now in my php script  i call that the stored
function which works properly when there is a record but when the record
doesnt exist, i would like to be able to place my own error message and not
e.g  'fatal error, .....'. how do i capture(in php)  the exception i raised
in postgres so that i know the record doesnt exist?


thanx.

On Wed, Apr 13, 2005 at 01:46:24AM -0400, Cima wrote:
>
> im working with php 4 and postgresql 8 and i would like to know how to
> handle certain errors generated. in postgresql,  i've written a stored
> function that selects a record from a table and in case no record is found i
> 'raise an exception'. fine, now in my php script  i call that the stored
> function which works properly when there is a record but when the record
> doesnt exist, i would like to be able to place my own error message and not
> e.g  'fatal error, .....'. how do i capture(in php)  the exception i raised
> in postgres so that i know the record doesnt exist?

You can use PHP's error handling capabilities to prevent errors
from being displayed automatically:

http://www.php.net/manual/en/ref.errorfunc.php

If you're sending queries with pg_query() then you can check its
return value to see if a query failed; if it did, you can call
pg_last_error() to get the error message.

http://www.php.net/manual/en/function.pg-query.php
http://www.php.net/manual/en/function.pg-last-error.php

If you're using other functions to interface with PostgreSQL then
see the documentation for those functions.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/