Re: exception handling in plpgsql - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: exception handling in plpgsql
Date
Msg-id 20060525224215.GA73000@winnie.fuhr.org
Whole thread Raw
In response to exception handling in plpgsql  (Roberto Assis <rezende_assis@yahoo.com.br>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Roberto Assis
Date:
Subject: exception handling in plpgsql
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL Question - S/B Good...