Index: openacs-4/packages/contacts/sql/postgresql/contacts-list-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-list-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/contacts/sql/postgresql/contacts-list-create.sql	3 Jan 2021 15:33:17 -0000	1.2
+++ openacs-4/packages/contacts/sql/postgresql/contacts-list-create.sql	5 Jan 2021 08:55:15 -0000	1.3
@@ -118,11 +118,11 @@
         'acs_object',
         null, 
         0, 
-        cast(null as integer),
+        null::integer,
         'acs_object', 
         null,
         0, 
-        cast(null as integer)
+        null::integer
     );
 
 select define_function_args('contact_owner__new','rel_id,rel_type;contact_owner,object_id_one,object_id_two,creation_user,creation_ip');
Index: openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b15-1.2b16.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b15-1.2b16.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b15-1.2b16.sql	26 Jun 2006 06:36:51 -0000	1.1
+++ openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b15-1.2b16.sql	5 Jan 2021 08:55:15 -0000	1.2
@@ -119,11 +119,11 @@
         'acs_object',
         null, 
         0, 
-        null,
+        null::integer,
         'acs_object', 
         null,
         0, 
-        null
+        null::integer
     );
 
 select define_function_args('contact_owner__new','rel_id,rel_type;contact_owner,object_id_one,object_id_two,creation_user,creation_ip');
Index: openacs-4/packages/dotfolio/sql/postgresql/admins-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotfolio/sql/postgresql/admins-init.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotfolio/sql/postgresql/admins-init.sql	2 Aug 2005 01:54:51 -0000	1.3
+++ openacs-4/packages/dotfolio/sql/postgresql/admins-init.sql	5 Jan 2021 08:55:15 -0000	1.4
@@ -43,7 +43,7 @@
         ''profiled_group'',
         null,
         0,
-        null,
+        null::integer,
         ''user'',
         null,
         0,
Index: openacs-4/packages/dotfolio/sql/postgresql/advisers-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotfolio/sql/postgresql/advisers-init.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotfolio/sql/postgresql/advisers-init.sql	2 Aug 2005 01:54:51 -0000	1.3
+++ openacs-4/packages/dotfolio/sql/postgresql/advisers-init.sql	5 Jan 2021 08:55:15 -0000	1.4
@@ -42,7 +42,7 @@
         ''profiled_group'',
         null,
         0,
-        null,
+        null::integer,
         ''user'',
         null,
         0,
Index: openacs-4/packages/dotfolio/sql/postgresql/guests-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotfolio/sql/postgresql/guests-init.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotfolio/sql/postgresql/guests-init.sql	2 Aug 2005 01:54:51 -0000	1.3
+++ openacs-4/packages/dotfolio/sql/postgresql/guests-init.sql	5 Jan 2021 08:55:15 -0000	1.4
@@ -42,7 +42,7 @@
         ''profiled_group'',
         null,
         0,
-        null,
+        null::integer,
         ''user'',
         null,
         0,
Index: openacs-4/packages/dotfolio/sql/postgresql/owners-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotfolio/sql/postgresql/owners-init.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotfolio/sql/postgresql/owners-init.sql	2 Aug 2005 01:54:51 -0000	1.3
+++ openacs-4/packages/dotfolio/sql/postgresql/owners-init.sql	5 Jan 2021 08:55:15 -0000	1.4
@@ -42,7 +42,7 @@
         ''profiled_group'',
         null,
         0,
-        null,
+        null::integer,
         ''user'',
         null,
         0,
Index: openacs-4/packages/dotfolio/sql/postgresql/users-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotfolio/sql/postgresql/users-init.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotfolio/sql/postgresql/users-init.sql	2 Aug 2005 01:54:51 -0000	1.3
+++ openacs-4/packages/dotfolio/sql/postgresql/users-init.sql	5 Jan 2021 08:55:15 -0000	1.4
@@ -40,7 +40,7 @@
         ''profiled_group'',
         null,
         0,
-        null,
+        null::integer,
         ''user'',
         null,
         0,
Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-memberships-create.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-memberships-create.sql	19 Sep 2005 05:53:13 -0000	1.6
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-memberships-create.sql	5 Jan 2021 08:55:15 -0000	1.7
@@ -353,11 +353,11 @@
         ''dotlrn_community'', 
 	null, 
         0,
-	null,
+	null::integer,
         ''user'',
 	''teaching_assistant'',
         0,
-	null
+	null::integer
     );
 
     perform acs_rel_type__create_type (
@@ -370,11 +370,11 @@
         ''dotlrn_ecom_instructor_rel'',
         ''dotlrn_community'', null, 
         0, 
-	null,
+	null::integer,
         ''user'', 
 	''instructor'',
         0, 
-	null
+	null::integer
     );
     
     return 0;
@@ -383,4 +383,4 @@
 ' language 'plpgsql';
 
 select inline_0();
-drop function inline_0();
\ No newline at end of file
+drop function inline_0();
Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d3-0.1d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d3-0.1d4.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d3-0.1d4.sql	9 Aug 2005 03:08:58 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d3-0.1d4.sql	5 Jan 2021 08:55:15 -0000	1.2
@@ -181,11 +181,11 @@
         ''dotlrn_community'', 
 	null, 
         0,
-	null,
+	null::integer,
         ''user'',
 	''teaching_assistant'',
         0,
-	null
+	null::integer
     );
 
     perform acs_rel_type__create_type (
@@ -198,11 +198,11 @@
         ''dotlrn_ecom_instructor_rel'',
         ''dotlrn_community'', null, 
         0, 
-	null,
+	null::integer,
         ''user'', 
 	''instructor'',
         0, 
-	null
+	null::integer
     );
     
     return 0;
Index: openacs-4/packages/address-book/sql/postgresql/address-book-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/sql/postgresql/address-book-create.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/address-book/sql/postgresql/address-book-create.sql	25 Jul 2004 11:18:28 -0000	1.6
+++ openacs-4/packages/address-book/sql/postgresql/address-book-create.sql	5 Jan 2021 08:56:03 -0000	1.7
@@ -487,11 +487,11 @@
    ''acs_object'',			--   object_type_one 
    null,				--   role_one
    0,					--   min_n_rels_one 
-   null,				--   max_n_rels_one
+   null::integer,		        --   max_n_rels_one
    ''ab_contact'',			--   object_type_two
    ''contact'',				--   role_two 
    0,					--   min_n_rels_two
-    null				--   max_n_rels_two
+    null::integer			--   max_n_rels_two
   );
 return 0;
 end;' language 'plpgsql';