Re: Triggers do the error checking

Janning Vygen wrote:
> 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.

    You  answered the question already. And in addition, doing it
    with triggers inside the database guarantees  you  can  never
    forget the check. The worst thing that can happen is that the
    frontend doesn't catch the ERROR and looks a little  puzzled.
    But your data is safe.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com