Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	7 Apr 2001 15:54:55 -0000	1.9
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	9 Apr 2001 04:55:14 -0000	1.10
@@ -244,7 +244,8 @@
         clr_keys_p      boolean default ''t'';
 begin
         if new.item_id = old.item_id and 
-           new.parent_id = old.parent_id then
+           ((new.parent_id = old.parent_id) or
+            (new.parent_id is null and old.parent_id is null)) then
 
            return new;
 
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/lob.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql	20 Mar 2001 06:02:57 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql	9 Apr 2001 04:55:14 -0000	1.4
@@ -82,7 +82,8 @@
         clr_keys_p      boolean default ''t'';
 begin
         if new.object_type = old.object_type and 
-           new.supertype = old.supertype then
+           ((new.supertype = old.supertype) or 
+            (new.supertype is null and old.supertype is null)) then
 
            return new;
 
Index: openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	8 Apr 2001 11:41:48 -0000	1.7
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	9 Apr 2001 04:55:14 -0000	1.8
@@ -101,7 +101,8 @@
         clr_keys_p      boolean default ''t'';
 begin
         if new.node_id = old.node_id and 
-           new.parent_id = old.parent_id then
+           ((new.parent_id = old.parent_id) or 
+            (new.parent_id is null and old.parent_id is null)) then
 
            return new;
 
Index: openacs-4/packages/acs-tcl/tcl/10-database-procs-postgresql.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/10-database-procs-postgresql.tcl,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-tcl/tcl/10-database-procs-postgresql.tcl	8 Apr 2001 16:13:03 -0000	1.7
+++ openacs-4/packages/acs-tcl/tcl/10-database-procs-postgresql.tcl	9 Apr 2001 04:55:14 -0000	1.8
@@ -116,6 +116,9 @@
 
     } error]
 
+    # error in the plsql anonymous function - try and drop it.
+    catch {ns_db dml $db "drop function $function_name ()"}
+
     global errorInfo errorCode
     set errinfo $errorInfo
     set errcode $errorCode