Re: Is it correct to raise an exception in a domain check

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Is it correct to raise an exception in a domain check
Дата
Msg-id CANzqJaBYUDRua2LYQHp6rZVAR2OUVe_65Hw-NFd_gA1pxksFzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Is it correct to raise an exception in a domain check  (Logan Grosz <logan.grosz@gmail.com>)
Список pgsql-general
On Tue, Jun 10, 2025 at 4:53 PM Logan Grosz <logan.grosz@gmail.com> wrote:
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.

Since PG will throw an error when any CHECK constraint fails, are you hoping to provide more details by throwing your own exception?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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