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 по дате отправления