Index: openacs-4/packages/calendar-portlet/www/calendar-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar-portlet/www/Attic/calendar-portlet-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/calendar-portlet/www/calendar-portlet-postgresql.xql	18 Jul 2002 18:24:54 -0000	1.1
+++ openacs-4/packages/calendar-portlet/www/calendar-portlet-postgresql.xql	3 Mar 2003 17:39:49 -0000	1.1.2.1
@@ -24,7 +24,7 @@
       and  e.activity_id = a.activity_id
       and  start_date between
         to_date(:current_date,:date_format) and
-        to_date(:current_date,:date_format) + (24 - 1/3600)/24
+        to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
       and e.event_id = ci.cal_item_id
       and c.calendar_id = ci.on_which_calendar
       and c.calendar_id in ($list_of_calendar_ids)
Index: openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql	9 Aug 2002 18:39:25 -0000	1.3
+++ openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql	3 Mar 2003 17:39:50 -0000	1.3.2.1
@@ -69,7 +69,7 @@
     into dotlrn_user_types
     (type, pretty_name, rel_type, group_id, segment_id)
     values
-    (''external'', ''Externals'', ''dotlrn_external_profile_rel'', gid, sid);
+    (''external'', ''External'', ''dotlrn_external_profile_rel'', gid, sid);
 
     select group_id
     into dotlrn_users_group_id