Constraint, Rule, or Trigger?

Поиск
Список
Период
Сортировка
Искать
От
Randall Perry
Тема
Constraint, Rule, or Trigger?
Дата
Msg-id
B79A12F0.E43D%rgp@systame.com
Список
Дерево обсуждения
Constraint, Rule, or Trigger? Randall Perry <rgp@systame.com>
I've had experience with SQL and database design, but not much with rules &
triggers. What's the best method to accomplish the following it PGSQL:

_Table A_ has a boolean field 'status'

_Table B_ has a 1-1 child relationship to Table A.

The rule, trigger, or contraint would have to enforce that: no record could
be created in B  if  the 'status' field was false in the parent record in A

Just point me in the right direction.
Thanks


-- 
Randy Perry
sysTame
Mac Consulting/Sales


В списке pgsql-general по дате отправления
От: Allan Engelhardt
Дата:
От: Joe Conway
Дата:
FAQ