Triggers do the error checking
| От | Janning Vygen |
|---|---|
| Тема | Triggers do the error checking |
| Дата | |
| Msg-id | 01062910444505.27577@janning обсуждение исходный текст |
| Ответы |
Re: Triggers do the error checking
|
| Список | pgsql-general |
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 по дате отправления: