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 -N -r1.10.2.1 -r1.10.2.2 --- openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql 7 Apr 2006 00:09:00 -0000 1.10.2.1 +++ openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql 7 Apr 2006 00:17:42 -0000 1.10.2.2 @@ -164,11 +164,11 @@ begin insert into timezone_rules (tz_id, abbrev, utc_start, utc_end, local_start, local_end, gmt_offset, isdst_p) - select timezone__get_id(tz), abbrev, rdbms_date(utc_start), - rdbms_date(utc_end), rdbms_date(local_start), - to_date(local_end), - gmt_offset, - case isdst_p when 0 then ''f'' else ''t''end; + select timezone__get_id(p_tz), p_abbrev, rdbms_date(p_utc_start), + rdbms_date(p_utc_end), rdbms_date(p_local_start), + to_date(p_local_end), + p_gmt_offset, + case p_isdst_p when 0 then ''f'' else ''t''end; end;' language 'plpgsql'; create or replace function timezone__convert_to_utc (integer, varchar) returns timestamptz as ' Index: openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql 7 Apr 2006 00:09:01 -0000 1.1.2.1 +++ openacs-4/packages/ref-timezones/sql/postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql 7 Apr 2006 00:17:42 -0000 1.1.2.2 @@ -11,9 +11,9 @@ begin insert into timezone_rules (tz_id, abbrev, utc_start, utc_end, local_start, local_end, gmt_offset, isdst_p) - select timezone__get_id(tz), abbrev, rdbms_date(utc_start), - rdbms_date(utc_end), rdbms_date(local_start), - to_date(local_end), - gmt_offset, - case isdst_p when 0 then ''f'' else ''t''end; + select timezone__get_id(p_tz), p_abbrev, rdbms_date(p_utc_start), + rdbms_date(p_utc_end), rdbms_date(p_local_start), + to_date(p_local_end), + p_gmt_offset, + case p_isdst_p when 0 then ''f'' else ''t''end; end;' language 'plpgsql';