Triggers do the error checking

Поиск
Список
Период
Сортировка
Искать
От
Janning Vygen
Тема
Triggers do the error checking
Дата
Msg-id
01062910444505.27577@janning
Список
Дерево обсуждения
Triggers do the error checking Janning Vygen <vygen@planwerk6.de>
Re: Triggers do the error checking Jan Wieck <JanWieck@Yahoo.com>
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
В списке pgsql-general по дате отправления
От: John Clark Naldoza y Lopez
Дата:
Сообщение: Re: Linux
От: Andy Samuel
Дата:
Сообщение: Re: Linux
FAQ