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
Дата: