Re: message for constraint - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: message for constraint
Date
Msg-id 200601141013.47717.peter_e@gmx.net
Whole thread Raw
In response to message for constraint  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: message for constraint  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: message for constraint
Next
From: Leandro Guimarães Faria Corcete DUTRA
Date:
Subject: Surrogate keys (Was: enums)