Jaime Casanova wrote:
> 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...
What about this?
=> create table foo (fld int4 constraint "fld must contain positive numbers" check (fld > 0));
CREATE TABLE
=> insert into foo values (-5);
ERROR: new row for relation "foo" violates check constraint "fld must contain positive numbers"
--
Peter Eisentraut
http://developer.postgresql.org/~petere/