Re: exception handling in plpgsql

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: exception handling in plpgsql
Дата
Msg-id 20060525224215.GA73000@winnie.fuhr.org
обсуждение исходный текст
Ответ на exception handling in plpgsql  (Roberto Assis <rezende_assis@yahoo.com.br>)
Список 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 по дате отправления:

Предыдущее
От: Roberto Assis
Дата:
Сообщение: exception handling in plpgsql
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: SQL Question - S/B Good...