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