message for constraint - Mailing list pgsql-hackers

From Jaime Casanova
Subject message for constraint
Date
Msg-id c2d9e70e0601132053o7f5a6813u35228374608c44df@mail.gmail.com
Whole thread Raw
Responses Re: message for constraint  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Improving N-Distinct estimation by ANALYZE
Next
From: Peter Eisentraut
Date:
Subject: Re: message for constraint