Index: openacs-4/packages/ref-timezones/ref-timezones.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-timezones/ref-timezones.info,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/ref-timezones/ref-timezones.info	12 Jul 2004 14:50:06 -0000	1.18
+++ openacs-4/packages/ref-timezones/ref-timezones.info	24 Jul 2004 15:10:14 -0000	1.19
@@ -7,14 +7,14 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.1.1" url="http://openacs.org/repository/download/apm/ref-timezones-5.1.1.apm">
+    <version name="5.2.0d2" url="http://openacs.org/repository/download/apm/ref-timezones-5.2.0d2.apm">
         <owner url="mailto:jon@mayuli.com">Jon Griffin</owner>
         <summary>Timezone data for acs-reference.</summary>
         <release-date>2004-04-29</release-date>
         <vendor url="http://www.mayuli.com">Mayuli Enterprises, LLC</vendor>
         <description format="text/plain">This is the timezone data for the acs-reference data package.  Used by acs-lang (among others) for localized times.</description>
 
-        <provides url="ref-timezones" version="5.1.1"/>
+        <provides url="ref-timezones" version="5.2.0d2"/>
         <requires url="acs-kernel" version="5.0.0"/>
         <requires url="acs-reference" version="5.0.0"/>
 
Index: openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql	11 Dec 2003 21:40:11 -0000	1.9
+++ openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql	24 Jul 2004 15:10:16 -0000	1.10
@@ -253,7 +253,7 @@
 create or replace function timezone__get_abbrev (integer, timestamptz) returns varchar as '
 declare
   p_tz_id alias for $1;
-  p_time for $2;
+  p_time alias for $2;
   v_abbrev timezone_rules.abbrev%TYPE;
 begin
   v_abbrev := ''GMT'';
Index: openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql	24 Jul 2004 15:10:16 -0000	1.1
@@ -0,0 +1,15 @@
+-- alias missing from p_time decl.
+create or replace function timezone__get_abbrev (integer, timestamptz) returns varchar as '
+declare
+  p_tz_id alias for $1;
+  p_time alias for $2;
+  v_abbrev timezone_rules.abbrev%TYPE;
+begin
+  v_abbrev := ''GMT'';
+
+  select abbrev into v_abbrev
+  from   timezone_rules
+  where  tz_id = p_tz_id and p_time between local_start and local_end;
+	 
+  return v_abbrev;
+end;' language 'plpgsql' stable;