On Wednesday 16 June 2010 00.56:14 Adrian Klaver wrote: > > My question is: why do I get information about too long value before > > trigger fires? > > Can I change this behavior?
I firmly feel friendly error messages like this firmly beong into the application and not into the DB. Next thing you'll want translated messages as well, and your triggers become so complex that you don't wnat to maintain them ...
My plan was to keep as much as possible of the application logic on the database side. Triggers were not so complex, because I used one trigger function for many tables (http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers),so printing user friendly information about null values was just one line.
> The database is beating you to the validation.
With triggers. A question to the experts: Couldn't this, in theory, be implememnted within the rules system? From what I understand they are run right after the query is parsed; I'd expect data validation to come a bit later. Not sure if this is right.