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 ;) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
