Hi !
Is it possible in postgres to define own message for some constraint?
Example:
If i create check constraint on zip_code column , i want to get
a message: "Zip code is invalid.Please,input code in format: nn-nnn"
and I want to send this message to the end user.
It will be much better(in my case) than "violates constraint
zip_code_check" :-) .
I can make this validation in trigger (and send msg to application by
notice or raise),but in this case i will duplicate validation
rules (in trigger and in constraint).Effect: Lower performance(i think)
and rules in two places...
Best regards and thanks for help,
Kacper Chrapa
----------------------------------------------------
Fantastyczna promocja w RUCHu! Rób zakupy, wysyłaj SMSy
i codziennie wygrywaj bony pieniężne!
W finale do wygrania Nissan NOTE.
Sprawdź: http://klik.wp.pl/?adr=www.loteriaruch.pl&sid=1062