updating table field whenever other table field changes

Поиск
Список
Период
Сортировка
От tech7890@yahoo.com (Andrew)
Тема updating table field whenever other table field changes
Дата
Msg-id ba957261.0303280712.4bce00b4@posting.google.com
обсуждение исходный текст
Ответы Re: updating table field whenever other table field changes  (Darren Ferguson <darren@crystalballinc.com>)
Re: updating table field whenever other table field changes  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello postgresql.questions group!

What do you think the best way to attack the following is:
parent table a - [status_field]

child table b - [status_field]

I need trigger or similar to achieve the following:
if a.status_field changes than all children of table a have their
b.status_field change to the same value as a.

However if b.status_field changes its parent record, a.status_field,
does not change.

Should I just create a separate update trigger or can I set this up
right when I am declaring these tables to achive this.

I also do not really understand CONSTRAINT TRIGGER and how it differs
from a regular old TRIGGER.  What do these internal TRIGGERS,
particularly "RI_FKey_noaction_upd" do?

Thanks for your time.  Any help or advice is appreciated.

-------
Andrew C.
tech7890@NOTPART@yahoo.com
Please remove characters 'NOTPART' from e-mail address above to e-mail
me

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: this date format thing.
Следующее
От: "Delao, Darryl W"
Дата:
Сообщение: Postgres Syslog