Is it correct to raise an exception in a domain check

Поиск
Список
Период
Сортировка
От Logan Grosz
Тема Is it correct to raise an exception in a domain check
Дата
Msg-id CANn=KGi1fU3rkEbwnOZX3_WNQJXa39tbkmn7N4tAMSf75r7nNw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is it correct to raise an exception in a domain check
Список pgsql-general
Hi,

I have a `DOMAIN` on `JSONB`. I need to verify the shape of the JSON, so I have a check expression written in PL/pgSQL. The docs say

> Each constraint must be an expression producing a Boolean result

Would it be correct to raise an exception to indicate a failed check? I perform type-casts (that throw already) and other checks that would benefit from attaching a description to the client error.

Thank you,
Logan

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