message for constraint

Поиск
Список
Период
Сортировка
Искать
От
Jaime Casanova
Тема
message for constraint
Дата
Msg-id
c2d9e70e0601132053o7f5a6813u35228374608c44df@mail.gmail.com
Список
Дерево обсуждения
message for constraint Jaime Casanova <systemguards@gmail.com>
Re: message for constraint Peter Eisentraut <peter_e@gmx.net>
Re: message for constraint Jaime Casanova <systemguards@gmail.com>
Hi,

From time to time people ask me if there is a way to "customize"
messages for constraints so they could be more informative to the
user...

Imagine something like:

create table foo (fld int4 check (fld > 0));
message for constraint foo_fld_check on foo is 'fld field must contain
possitive numbers only.';

so i can let this message go directly to my users, and they can
respond without knowing waht a check constraint is...

we can use the pg_description catalog with a column added to indicate
if it is a comment or a message for constraint...

what do you think, it's worth the effort?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Peter Eisentraut
Дата:
Сообщение: Re: message for constraint
FAQ