On 1/14/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> 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/
>
ok, i didn't know you can use such names...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
