FOREIGN KEYs ... I think ...

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема FOREIGN KEYs ... I think ...
Дата
Msg-id 20060104213210.A1088@ganymede.hub.org
обсуждение исходный текст
Ответы Re: FOREIGN KEYs ... I think ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: FOREIGN KEYs ... I think ...  (nospam@hardgeus.com)
Re: FOREIGN KEYs ... I think ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список pgsql-sql
I'm not sure if I'm looking at (for) the right thing or not, but if I am, 
then I'm not finding any useful examples :(

I have two tables, simplified as:

CREATE TABLE incident_summary (  id serial,  subject text,  status boolean
);

CREATE TABLE incident_comments (  id serial,  incident_id int4,  body text,  comment_date timestamp,  status boolean
);

Now, what I want to do is add a FOREIGN KEY (again, I think) that when 
incident_summary.status is changed (either closed, or reopened), the 
associated records in incident_comments are changed to the same state ...

It *looks* like it should be simple enough, I want 
incident_comments.status to change to incident_summary.status whenever 
incident_summary.status changes ... since I'm finding nothing searching on 
FOREIGN KEYS, I'm guessing that I'm looking at the wrong thing ...

So, what should I be searching on / reading for this one?  Pointers 
preferred, especially one with some good examples :)

Thanks ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


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

Предыдущее
От: "Scott, Casey"
Дата:
Сообщение: JOIN question with multiple records
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FOREIGN KEYs ... I think ...