Re: PLPGSQL/EXCEPTION HANDLING

Поиск
Список
Период
Сортировка
От renneyt@yahoo.com
Тема Re: PLPGSQL/EXCEPTION HANDLING
Дата
Msg-id 448EC40A.5020102@yahoo.com
обсуждение исходный текст
Ответ на Re: PLPGSQL/EXCEPTION HANDLING  ("Jaime Casanova" <systemguards@gmail.com>)
Ответы Re: PLPGSQL/EXCEPTION HANDLING
Список pgsql-admin
Jaime Casanova wrote:
> On 6/12/06, renneyt@yahoo.com <renneyt@yahoo.com> wrote:
>> In a function implemented in 7.4.8 I had the following error when I call
>> the function:
>>
>> ERROR:  syntax error at or near "EXCEPTION"
>>
>> Offending line is:
>>     EXCEPTION WHEN dup_val_on_index THEN NULL;
>>
>> When this line is removed, all is well.
>>
>
> that's because that construction was added in 8.0, you have to upgrade
> to use it
>
What part of the original  construction is  not supported?
Are any "exception when" statements supported?

Thanks

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jaime Casanova"
Дата:
Сообщение: Re: PLPGSQL/EXCEPTION HANDLING
Следующее
От: "renneyt@yahoo.com"
Дата:
Сообщение: Re: pg_dump/restore problem