Re: Assertions in PL/PgSQL

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: Assertions in PL/PgSQL
Дата
Msg-id 52400342.206@joh.to
обсуждение исходный текст
Ответ на Re: Assertions in PL/PgSQL  (Marko Tiikkaja <marko@joh.to>)
Ответы Re: Assertions in PL/PgSQL  (Andres Freund <andres@2ndquadrant.com>)
Re: Assertions in PL/PgSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On 9/23/13 10:50 AM, I wrote:
> On 9/23/13 6:40 AM, Pavel Stehule wrote:
>> After days I am thinking so it can be a good solution
>>
>> syntax - enhanced current RAISE
>>
>> RAISE ASSERT WHEN boolean expression
>>
>> RAISE ASSERT 'some message' WHEN expression
>
> It looks like I'm losing this battle, but this syntax isn't too bad.
>
>> and we can have a GUC that controls asserts per database - possibly
>> overwritten by plpgsql option - similar to current plpgsql options
>>
>> assert_level = [*ignore*, notice, warning, error]
>
> This sounds like a decent enhancement.

Oh, it would be nice to have the option here to say "assertions can't be 
caught by exception handlers", but I don't know how that mechanism works 
so I'm not sure it's possible.  I'll have to look into that.


Regards,
Marko Tiikkaja



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Assertions in PL/PgSQL
Следующее
От: Amit Khandekar
Дата:
Сообщение: Re: Assertions in PL/PgSQL