From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: FOREIGN KEYs ... I think ... |
Date: | 2006-01-05 03:12:27 |
Message-ID: | 20060104230722.N1088@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wed, 4 Jan 2006, Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
>> 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 ...
>
> Why not just get rid of the status column in incident_comments, and
> treat incident_summary.status as the sole copy of the state? When you
> need to get to it from incident_comments, you do a join.
I may end up getting to that point ...
> The foreign key you really ought to have here is from
> incident_comments.incident_id to incident_summary.id
> (assuming that I've understood your schema correctly).
'k, where I'm getting lost here is how do I get status changed in
_comments on UPDATE of incident_summary.id? There doesn't seem to be
anything for ON UPDATE to 'run SQL query' or some such ... or I'm reading
old docs :( This is the part that I'm having a bugger of a time wrapping
my head around ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Johannsen | 2006-01-05 03:31:47 | Re: FOREIGN KEYs ... I think ... |
Previous Message | Tom Lane | 2006-01-05 01:54:47 | Re: FOREIGN KEYs ... I think ... |