Hi,
i am new to the concepts of SQL and Postgresql.
i am just thinking about some database design decisions.
at this time my tabel has many trigger functions to check the inserted or
updated values.
Some checks could be done via a check constraint, but i wont get individual
error-messages. With triggers i can raise exceptions in a different language
which my php frontend can show to the user.
So the whole error checking is done inside the database with triggers.
Is this ok? or is it a bad design decision. I dont want my frontend(gui, php
site) to do the error checking because i dont want to write things a thousand
times.
janning
--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf
fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de