Index: openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql,v
diff -u -N -r1.3 -r1.3.18.1
--- openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql	18 Jul 2002 18:51:37 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql	6 Feb 2008 08:46:01 -0000	1.3.18.1
@@ -9,13 +9,15 @@
     object_id                       integer
                                     constraint snom_object_id_fk
                                     references acs_objects (object_id)
+                                    on update cascade on delete cascade
                                     constraint snom_object_id_nn
                                     not null
                                     constraint site_node_object_mappings_pk
                                     primary key,
     node_id                         integer
                                     constraint snom_node_id_fk
                                     references site_nodes (node_id)
+                                    on update cascade on delete cascade
                                     constraint snom_node_id_nn
                                     not null
 );
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql	6 Feb 2008 08:46:02 -0000	1.1.2.1
@@ -0,0 +1,6 @@
+-- adding missing cascade part
+ALTER TABLE site_node_object_mappings DROP CONSTRAINT snom_object_id_fk;
+ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_object_id_fk FOREIGN KEY (object_id) REFERENCES acs_objects (object_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+ALTER TABLE site_node_object_mappings DROP CONSTRAINT snom_node_id_fk;
+ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_node_id_fk FOREIGN KEY (object_id) REFERENCES acs_objects (object_id) ON UPDATE CASCADE ON DELETE CASCADE;