Tom Lane wrote:
CREATE TABLE parent (id INT, cola CHAR(1), common CHAR(1));
CREATE TABLE child (id INT, parent_id INT, cola(1), common(1));

What I need, is when "common" is changed for a parent, then that new value is reflected in "common" for all the children, ie:
...
Problem is, when "common" is changed for a child, I need the parent and all siblings to reflect that value too, ie:

Seems to me that your real problem is a bogus database layout. If there should only be one "common" value for a parent and children, then only store one value ... that is, "common" should exist only in the parent. ...

Sorry, I should have mentioned that there is a lot more to the design that makes this replication necessary, including another two levels to the tree plus the ability to have orphaned children.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to