Re: exception handling in plpgsql

[Michael Fuhr <mike(at)fuhr(dot)org>]

On Thu, May 25, 2006 at 10:25:37PM +0000, Roberto Assis wrote:
> Hello folks, supose I already have an user called bob, with this
> function below I was expecting to see something like this:
>   -------------------------------------------------------------------------------
>   SELECT my_create_user('bob','bobpass');
>   ERROR: <Some string like XXXXX>:<Some text>
>   -------------------------------------------------------------------------------
>    If I try to make another user bob.
>   But instead the function doesn't compile.
>   Reading the manual it seemed that this should work.

What's the exact error you get?  What version of PostgreSQL are you
using?  SQLSTATE and SQLERRM are available only since 8.1.

-- 
Michael Fuhr