error handling - Mailing list pgsql-novice

From Cima
Subject error handling
Date
Msg-id 003101c53fec$2698d870$f00110ac@doctorado1
Whole thread Raw
Responses Re: error handling
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Slavisa Garic
Date:
Subject: Re: [PERFORM] Many connections lingering
Next
From: David Orme
Date:
Subject: Re: SUMMARY - select top N entries from several groups