Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-callback-package-body.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-callback-package-body.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-callback-package-body.sql 19 Nov 2001 18:20:33 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-callback-package-body.sql 2 Mar 2003 22:36:45 -0000 1.1.4.1 @@ -21,7 +21,7 @@ -- function time_sysdate_plus_x create function wf_callback__time_sysdate_plus_x (integer,varchar,text) -returns timestamp as ' +returns timestamptz as ' declare time_sysdate_plus_x__case_id alias for $1; time_sysdate_plus_x__transition_key alias for $2; Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql,v diff -u -r1.5 -r1.5.4.1 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql 19 Nov 2001 18:20:33 -0000 1.5 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql 2 Mar 2003 22:36:45 -0000 1.5.4.1 @@ -577,7 +577,7 @@ on delete cascade, workflow_key varchar(100), transition_key varchar(100), - deadline timestamp + deadline timestamptz constraint wf_case_deadline_nn not null, -- table constraints -- @@ -617,21 +617,21 @@ constraint wf_task_state_ck check (state in ('enabled','started','canceled', 'finished','overridden')), - enabled_date timestamp default now(), - started_date timestamp, - canceled_date timestamp, - finished_date timestamp, - overridden_date timestamp, + enabled_date timestamptz default now(), + started_date timestamptz, + canceled_date timestamptz, + finished_date timestamptz, + overridden_date timestamptz, /* -- TIME transition info */ - trigger_time timestamp, + trigger_time timestamptz, /* -- USER transition info */ - deadline timestamp, + deadline timestamptz, estimated_minutes integer, holding_user integer constraint wf_task_holding_user_fk references users(user_id) on delete cascade, - hold_timeout timestamp, + hold_timeout timestamptz, -- table constraints -- constraint wf_task_transition_fk foreign key (workflow_key, transition_key) references wf_transitions(workflow_key, transition_key) @@ -687,10 +687,10 @@ constraint wf_token_task_fk references wf_tasks(task_id), -- info on state changes - produced_date timestamp default now(), - locked_date timestamp, - canceled_date timestamp, - consumed_date timestamp, + produced_date timestamptz default current_timestamp, + locked_date timestamptz, + canceled_date timestamptz, + consumed_date timestamptz, produced_journal_id integer constraint wf_token_produced_journal_fk references journal_entries(journal_id), Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql,v diff -u -r1.5.4.1 -r1.5.4.2 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 21 Jan 2003 13:48:12 -0000 1.5.4.1 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 2 Mar 2003 22:36:45 -0000 1.5.4.2 @@ -1,6 +1,6 @@ -- create or replace package body workflow_case -- function new -create function workflow_case__new (integer,varchar,varchar,integer,timestamp with time zone,integer,varchar) +create function workflow_case__new (integer,varchar,varchar,integer,timestamptz,integer,varchar) returns integer as ' declare new__case_id alias for $1; -- default null @@ -855,7 +855,7 @@ -- procedure set_case_deadline -create function workflow_case__set_case_deadline (integer,varchar,timestamp with time zone) +create function workflow_case__set_case_deadline (integer,varchar,timestamptz) returns integer as ' declare set_case_deadline__case_id alias for $1; @@ -986,7 +986,7 @@ -- function execute_time_callback create function workflow_case__execute_time_callback (varchar,varchar,integer,varchar) -returns timestamp as ' +returns timestamptz as ' declare execute_time_callback__callback alias for $1; execute_time_callback__custom_arg alias for $2; @@ -1016,14 +1016,14 @@ -- function get_task_deadline create function workflow_case__get_task_deadline (varchar,varchar,varchar,integer,varchar) -returns timestamp as ' +returns timestamptz as ' declare get_task_deadline__callback alias for $1; get_task_deadline__custom_arg alias for $2; get_task_deadline__attribute_name alias for $3; get_task_deadline__case_id alias for $4; get_task_deadline__transition_key alias for $5; - v_deadline timestamp; + v_deadline timestamptz; v_rec record; v_str varchar; begin @@ -1070,13 +1070,13 @@ -- function execute_hold_timeout_callback create function workflow_case__execute_hold_timeout_callback (varchar,varchar,integer,varchar) -returns timestamp as ' +returns timestamptz as ' declare execute_hold_timeout_callback__callback alias for $1; execute_hold_timeout_callback__custom_arg alias for $2; execute_hold_timeout_callback__case_id alias for $3; execute_hold_timeout_callback__transition_key alias for $4; - v_hold_timeout timestamp; + v_hold_timeout timestamptz; v_rec record; v_str text; begin @@ -1652,8 +1652,8 @@ enable_transitions__case_id alias for $1; v_task_id integer; v_workflow_key varchar; - v_trigger_time timestamp; - v_deadline_date timestamp; + v_trigger_time timestamptz; + v_deadline_date timestamptz; v_party_from integer; v_subject varchar; v_body text; @@ -1932,7 +1932,7 @@ v_transition_key varchar(100); v_hold_timeout_callback varchar(100); v_hold_timeout_custom_arg varchar(4000); - v_hold_timeout timestamp; + v_hold_timeout timestamptz; place_rec record; begin PERFORM workflow_case__ensure_task_in_state(start_task__task_id, Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-create.sql,v diff -u -r1.5.2.1 -r1.5.2.2 --- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-create.sql 6 Feb 2003 12:57:38 -0000 1.5.2.1 +++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-create.sql 2 Mar 2003 22:38:20 -0000 1.5.2.2 @@ -199,7 +199,7 @@ check (status in ('unmoderated', 'approved', 'rejected')) constraint bboard_fmm_status_nn not null, - last_reply_date timestamp, + last_reply_date timestamptz, num_replies integer, constraint bboard_forum_message_map_pk primary key (forum_id, message_id) Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql 9 Mar 2002 02:00:02 -0000 1.4 +++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql 2 Mar 2003 22:38:20 -0000 1.4.4.1 @@ -55,24 +55,24 @@ drop function bboard_forum__forum_p (integer); drop function bboard_forum__new (integer, varchar, varchar, char, integer, - integer, timestamp, integer, varchar, varchar); + integer, timestamptz, integer, varchar, varchar); drop function bboard_forum__delete (integer); drop function bboard_forum__set_attrs (integer, varchar, varchar, char, integer); drop function bboard_forum__subscribe (integer, integer); drop function bboard_forum__forum_containing_message (integer); drop function bboard_forum__name (integer); drop function bboard_category__category_p (integer); drop function bboard_category__new (integer, varchar, varchar, integer, - integer, timestamp, integer, varchar, varchar); + integer, timestamptz, integer, varchar, varchar); drop function bboard_category__delete (integer); drop function bboard_category__set_attrs (integer, varchar, varchar, integer); drop function bboard_category__subscribe (integer, integer); drop function bboard_category__name (integer); -drop function bboard_message__new (integer, integer, timestamp, integer, +drop function bboard_message__new (integer, integer, timestamptz, integer, varchar, varchar, varchar, varchar, text, - integer, timestamp, integer, varchar, varchar); + integer, timestamptz, integer, varchar, varchar); drop function bboard_message__message_p (integer); -drop function bboard_message__set_attrs (integer, integer, timestamp, +drop function bboard_message__set_attrs (integer, integer, timestamptz, integer, varchar, varchar, integer); drop function bboard_message__set_status (integer, integer, varchar); drop function bboard_message__add_category (integer, integer); Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql,v diff -u -r1.8 -r1.8.2.1 --- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql 13 Mar 2002 22:50:53 -0000 1.8 +++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql 2 Mar 2003 22:38:20 -0000 1.8.2.1 @@ -28,7 +28,7 @@ create function bboard_forum__new (integer, varchar, varchar, char, integer, - integer, timestamp, integer, varchar, varchar) + integer, timestamptz, integer, varchar, varchar) returns integer as ' declare p_forum_id alias for $1; -- default null @@ -180,7 +180,7 @@ create function bboard_category__new (integer, varchar, varchar, integer, - integer, timestamp, integer, varchar, varchar) + integer, timestamptz, integer, varchar, varchar) returns integer as ' declare p_category_id alias for $1; -- default null @@ -289,9 +289,9 @@ --------------- bboard_message package ---------------- -create function bboard_message__new (integer, integer, timestamp, integer, +create function bboard_message__new (integer, integer, timestamptz, integer, varchar, varchar, varchar, varchar, text, - integer, timestamp, integer, varchar, varchar) + integer, timestamptz, integer, varchar, varchar) returns integer as ' declare p_message_id alias for $1; -- default null @@ -309,7 +309,7 @@ p_creation_ip alias for $13; -- default null p_object_type alias for $14; -- default ''bboard_message'' v_message_id bboard_messages.message_id%TYPE; - v_sent_date timestamp; + v_sent_date timestamptz; begin v_sent_date := coalesce(p_sent_date, now()); @@ -360,7 +360,7 @@ ' language 'plpgsql'; -create function bboard_message__set_attrs (integer, integer, timestamp, +create function bboard_message__set_attrs (integer, integer, timestamptz, integer, varchar, varchar, integer) returns integer as ' declare Index: openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-oracle.xql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-oracle.xql 26 Apr 2002 21:43:03 -0000 1.4 +++ openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-oracle.xql 2 Mar 2003 22:32:26 -0000 1.4.2.1 @@ -7,38 +7,38 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday')) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday')) as sunday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday'),'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday'),'J') as sunday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 1) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 1) as monday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 1,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 1,'J') as monday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 2) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 2) as tuesday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 2,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 2,'J') as tuesday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 3) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 3) as wednesday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 3,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 3,'J') as wednesday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 4) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 4) as thursday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 4,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 4,'J') as thursday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 5) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 5) as friday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 5,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 5,'J') as friday_julian, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 6) +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 6) as saturday_date, -to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 6,'J') +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'Sunday') + 6,'J') as saturday_julian, -to_date(:current_date,'yyyy-mm-dd') - 7 as last_week, -to_char(to_date(:current_date, 'yyyy-mm-dd') - 7,'Month DD, YYYY') as last_week_pretty, -to_date(:current_date,'yyyy-mm-dd') + 7 as next_week, -to_char(to_date(:current_date, 'yyyy-mm-dd') + 7,'Month DD, YYYY') as next_week_pretty +to_date(:current_date,'yyyy-mm-dd') - cast(7 as interval) as last_week, +to_char(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval),'Month DD, YYYY') as last_week_pretty, +to_date(:current_date,'yyyy-mm-dd') + cast(7 as interval) as next_week, +to_char(to_date(:current_date, 'yyyy-mm-dd') + cast(7 as interval),'Month DD, YYYY') as next_week_pretty from dual @@ -47,9 +47,9 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'Day, DD Month YYYY') as day_of_the_week, -to_char(to_date(:current_date, 'yyyy-mm-dd')-1, 'yyyy-mm-dd') +to_char(to_date(:current_date, 'yyyy-mm-dd') - cast(1 as interval), 'yyyy-mm-dd') as yesterday, -to_char(to_date(:current_date, 'yyyy-mm-dd')+1, 'yyyy-mm-dd') +to_char(to_date(:current_date, 'yyyy-mm-dd') + cast(1 as interval), 'yyyy-mm-dd') as tomorrow from dual Index: openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql,v diff -u -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql 21 Jan 2003 13:45:18 -0000 1.4.2.1 +++ openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql 2 Mar 2003 22:32:26 -0000 1.4.2.2 @@ -35,10 +35,10 @@ as saturday_date, to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') + 6,'J') as saturday_julian, -:current_date::timestamp - '7 days'::timespan as last_week, -to_char(:current_date::timestamp - '7 days'::interval, 'Month DD, YYYY') as last_week_pretty, -:current_date::timestamp + '7 days'::timespan as next_week, -to_char(:current_date::timestamp + '7 days'::interval, 'Month DD, YYYY') as next_week_pretty +:current_date::timestamptz - '7 days'::interval as last_week, +to_char(:current_date::timestamptz - '7 days'::interval, 'Month DD, YYYY') as last_week_pretty, +:current_date::timestamptz + '7 days'::interval as next_week, +to_char(:current_date::timestamptz + '7 days'::interval, 'Month DD, YYYY') as next_week_pretty from dual Index: openacs-4/packages/acs-events/sql/postgresql/test/acs-events-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/test/acs-events-test.sql,v diff -u -r1.2.4.1 -r1.2.4.2 --- openacs-4/packages/acs-events/sql/postgresql/test/acs-events-test.sql 21 Jan 2003 13:45:43 -0000 1.2.4.1 +++ openacs-4/packages/acs-events/sql/postgresql/test/acs-events-test.sql 2 Mar 2003 22:33:06 -0000 1.2.4.2 @@ -60,8 +60,8 @@ end;' language 'plpgsql'; -- This is an example of a simple custom recurrence function: recur every three days -create function recur_every3(timestamp with time zone,integer) -returns timestamp as ' +create function recur_every3(timestamptz,integer) +returns timestamptz as ' declare recur_every3__date alias for $1; recur_every3__interval alias for $2; @@ -79,8 +79,8 @@ create function ut__insert_instances() returns integer as ' declare - date1 timestamp := ''2000-03-23 13:00''; - date2 timestamp := ''2000-03-23 14:00''; + date1 timestamptz := ''2000-03-23 13:00''; + date2 timestamptz := ''2000-03-23 14:00''; insert_instances__timespan_id acs_events.timespan_id%TYPE; insert_instances__activity_id acs_events.activity_id%TYPE; insert_instances__recurrence_id acs_events.recurrence_id%TYPE; @@ -281,7 +281,7 @@ -- Insert instances PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2000-06-02'' + timestamptz ''2000-06-02'' ); -- Test for instances @@ -340,8 +340,8 @@ -- Another test of weekly recurrence - insert_instances__timespan_id := timespan__new(timestamp ''2001-10-21 09:00:00'', - timestamp ''2001-10-23 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-10-21 09:00:00'', + timestamptz ''2001-10-23 10:00:00''); -- Check month by date (recur for the same date of the month specified in time interval) insert_instances__recurrence_id := recurrence__new(''week'', @@ -360,7 +360,7 @@ PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-12-25'' + timestamptz ''2001-12-25'' ); -- There should be 13 instances of the weekly event @@ -386,8 +386,8 @@ -- Test month_by_date recurrence - insert_instances__timespan_id := timespan__new(timestamp ''2001-03-21 09:00:00'', - timestamp ''2001-03-23 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-03-21 09:00:00'', + timestamptz ''2001-03-23 10:00:00''); -- Check month by date (recur for the same date of the month specified in time interval) insert_instances__recurrence_id := recurrence__new(''month_by_date'', @@ -406,7 +406,7 @@ PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-04-25 00:00:00'' + timestamptz ''2001-04-25 00:00:00'' ); -- There should be two instances (including the original), even if the cut-off date is between @@ -430,8 +430,8 @@ end loop; -- Test month_by_date recurrence - insert_instances__timespan_id := timespan__new(timestamp ''2001-10-21 09:00:00'', - timestamp ''2001-10-23 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-10-21 09:00:00'', + timestamptz ''2001-10-23 10:00:00''); -- Check month by date (recur for the same date of the month specified in time interval) insert_instances__recurrence_id := recurrence__new(''month_by_date'', @@ -450,7 +450,7 @@ PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2002-04-25 00:00:00'' + timestamptz ''2002-04-25 00:00:00'' ); -- There should be four instances (including the original), even if the cut-off date is between @@ -480,8 +480,8 @@ -- Check another recurrence type (daily recurrence) -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-03-26 09:00:00'', - timestamp ''2001-03-26 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-03-26 09:00:00'', + timestamptz ''2001-03-26 10:00:00''); -- Check month by date (recur every day, skip every second interval) insert_instances__recurrence_id := recurrence__new(''day'', @@ -501,7 +501,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-04-05 00:00:00'' + timestamptz ''2001-04-05 00:00:00'' ); -- There should be six instances (including the original) @@ -530,8 +530,8 @@ -- Check another recurrence type (daily recurrence) -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-10-26 09:00:00'', - timestamp ''2001-10-26 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-10-26 09:00:00'', + timestamptz ''2001-10-26 10:00:00''); -- Check month by date (recur every day, skip every second interval) insert_instances__recurrence_id := recurrence__new(''day'', @@ -551,7 +551,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-11-05 00:00:00'' + timestamptz ''2001-11-05 00:00:00'' ); -- There should be five instances (including the original) @@ -580,8 +580,8 @@ -- Check another recurrence type (same date every year) -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-04-01 09:00:00'', - timestamp ''2001-04-01 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-04-01 09:00:00'', + timestamptz ''2001-04-01 10:00:00''); -- Check month by date (recur every day, skip every second interval) insert_instances__recurrence_id := recurrence__new(''year'', @@ -601,7 +601,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2002-04-05 00:00:00'' + timestamptz ''2002-04-05 00:00:00'' ); -- There should be two instance (including the original). @@ -623,8 +623,8 @@ -- Check another recurrence type (same date every year) -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-04-03 09:00:00'', - timestamp ''2001-04-03 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-04-03 09:00:00'', + timestamptz ''2001-04-03 10:00:00''); -- Check month by date (recur every day, skip every second interval) insert_instances__recurrence_id := recurrence__new(''year'', @@ -644,7 +644,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2002-04-05 00:00:00'' + timestamptz ''2002-04-05 00:00:00'' ); -- There should be two instance (including the original). @@ -667,8 +667,8 @@ -- Check another recurrence type (same date every year) -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-10-28 09:00:00'', - timestamp ''2001-10-28 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-10-28 09:00:00'', + timestamptz ''2001-10-28 10:00:00''); -- Check month by date (recur every day, skip every second interval) insert_instances__recurrence_id := recurrence__new(''year'', @@ -688,7 +688,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2002-10-30 00:00:00'' + timestamptz ''2002-10-30 00:00:00'' ); -- There should be two instance (including the original). @@ -710,8 +710,8 @@ -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-02-06 09:00:00'', - timestamp ''2001-02-07 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-02-06 09:00:00'', + timestamptz ''2001-02-07 10:00:00''); insert_instances__recurrence_id := recurrence__new(''last_of_month'', 1, @@ -730,7 +730,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-12-10 00:00:00'' + timestamptz ''2001-12-10 00:00:00'' ); -- There should be three instances (including the original). @@ -756,8 +756,8 @@ -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-08-06 09:00:00'', - timestamp ''2001-08-07 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-08-06 09:00:00'', + timestamptz ''2001-08-07 10:00:00''); insert_instances__recurrence_id := recurrence__new(''last_of_month'', 1, @@ -776,7 +776,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2002-05-20 00:00:00'' + timestamptz ''2002-05-20 00:00:00'' ); -- There should be three instances (including the original). @@ -802,8 +802,8 @@ ---------------------------------------------------------------------------------------------------------- -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-08-06 09:00:00'', - timestamp ''2001-08-07 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-08-06 09:00:00'', + timestamptz ''2001-08-07 10:00:00''); insert_instances__recurrence_id := recurrence__new(''custom'', 1, @@ -822,7 +822,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-08-30 00:00:00'' + timestamptz ''2001-08-30 00:00:00'' ); -- There should be three instances (including the original). @@ -849,8 +849,8 @@ ---------------------------------------------------------------------------------------------------------- -- First, we need a new timespan,recurrence and activity - insert_instances__timespan_id := timespan__new(timestamp ''2001-02-06 09:00:00'', - timestamp ''2001-02-07 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-02-06 09:00:00'', + timestamptz ''2001-02-07 10:00:00''); insert_instances__recurrence_id := recurrence__new(''month_by_day'', 1, @@ -869,7 +869,7 @@ -- Cut-off date should have no effect PERFORM acs_event__insert_instances (insert_instances__event_id, - timestamp ''2001-12-20 00:00:00'' + timestamptz ''2001-12-20 00:00:00'' ); -- There should be three instances (including the original). @@ -914,8 +914,8 @@ ---------------------------------------------------------------------------------------------------------- -- Timespan to shift - insert_instances__timespan_id := timespan__new(timestamp ''2001-02-06 09:00:00'', - timestamp ''2001-02-07 10:00:00''); + insert_instances__timespan_id := timespan__new(timestamptz ''2001-02-06 09:00:00'', + timestamptz ''2001-02-07 10:00:00''); -- Insert one recurrence so that recurrence__delete will have something to delete (since recurrences Index: openacs-4/packages/acs-events/sql/postgresql/test/time_intervals-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/test/time_intervals-test.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/test/time_intervals-test.sql 13 Jul 2001 03:16:32 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/test/time_intervals-test.sql 2 Mar 2003 22:33:06 -0000 1.1.4.1 @@ -67,8 +67,8 @@ -- We test the creation of a time interval entry create function ut__new( - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' declare @@ -135,8 +135,8 @@ create function ut__edit ( integer, -- time_intervals.interval_id%TYPE; - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' declare @@ -209,8 +209,8 @@ integer, -- in time_intervals.interval_id%TYPE; integer, integer, - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' declare @@ -268,8 +268,8 @@ create function ut__overlaps_p( varchar, integer, -- time_intervals.interval_id%TYPE; - timestamp, -- time_intervals.start_date%TYPE; - timestamp, -- time_intervals.end_date%TYPE; + timestamptz, -- time_intervals.start_date%TYPE; + timestamptz, -- time_intervals.end_date%TYPE; boolean ) returns integer as ' @@ -294,10 +294,10 @@ create function ut__overlaps_p( varchar, - timestamp, - timestamp, - timestamp, -- time_intervals.start_date%TYPE; - timestamp, -- time_intervals.end_date%TYPE; + timestamptz, + timestamptz, + timestamptz, -- time_intervals.start_date%TYPE; + timestamptz, -- time_intervals.end_date%TYPE; boolean ) returns integer as ' @@ -372,46 +372,46 @@ raise notice ''Regression test, part 1 (creates and edits).''; -- We first check if the creation of time intervals work - v_interval_id := ut__new(timestamp ''2001-01-01'',timestamp ''2001-01-02''); + v_interval_id := ut__new(timestamptz ''2001-01-01'',timestamptz ''2001-01-02''); -- Try to edit, putting new values for start date and end dates - PERFORM ut__edit(v_interval_id,timestamp ''2001-01-02'',timestamp ''2001-01-30''); + PERFORM ut__edit(v_interval_id,timestamptz ''2001-01-02'',timestamptz ''2001-01-30''); -- Edit, but this time, change only the start date - PERFORM ut__edit(v_interval_id,timestamp ''2001-01-07'',null); + PERFORM ut__edit(v_interval_id,timestamptz ''2001-01-07'',null); -- Edit, but this time, change only the end date - PERFORM ut__edit(v_interval_id,null,timestamp ''2001-01-08''); + PERFORM ut__edit(v_interval_id,null,timestamptz ''2001-01-08''); -- We now test equality of (identical) intervals PERFORM ut__eq(''Equal (same) intervals'',v_interval_id,v_interval_id,true); -- Create another interval for comparison - v_interval_id_ck := ut__new(timestamp ''2001-01-07'',timestamp ''2001-01-08''); + v_interval_id_ck := ut__new(timestamptz ''2001-01-07'',timestamptz ''2001-01-08''); -- We now test equality of (nonidentical) intervals PERFORM ut__eq(''Equal (distinct) intervals'',v_interval_id,v_interval_id_ck,true); -- Shift the second interval start date by one day, the end date by two days - PERFORM ut__shift(v_interval_id_ck,1,2,timestamp ''2001-01-08'', timestamp ''2001-01-10''); + PERFORM ut__shift(v_interval_id_ck,1,2,timestamptz ''2001-01-08'', timestamptz ''2001-01-10''); -- Now test inequality of time intervals PERFORM ut__eq(''Unequal (distinct) intervals'',v_interval_id,v_interval_id_ck,false); -- Shift the second interval start date BACK by one day, the end date same - PERFORM ut__shift(v_interval_id_ck,-1,0,timestamp ''2001-01-07'', timestamp ''2001-01-10''); + PERFORM ut__shift(v_interval_id_ck,-1,0,timestamptz ''2001-01-07'', timestamptz ''2001-01-10''); -- Now test inequality of time intervals PERFORM ut__eq(''Unequal (distinct) intervals: start date equal'',v_interval_id,v_interval_id_ck,false); -- Shift the second interval, start date same, but the end date BACK by two days - PERFORM ut__shift(v_interval_id_ck,0,-2,timestamp ''2001-01-07'', timestamp ''2001-01-08''); + PERFORM ut__shift(v_interval_id_ck,0,-2,timestamptz ''2001-01-07'', timestamptz ''2001-01-08''); -- Should be equal again PERFORM ut__eq(''Equal again, (distinct) intervals'',v_interval_id,v_interval_id_ck,true); -- For fun, shift start date BACK by two days, the end date BACK by 1 day - PERFORM ut__shift(v_interval_id_ck,-2,-1,timestamp ''2001-01-05'', timestamp ''2001-01-07''); + PERFORM ut__shift(v_interval_id_ck,-2,-1,timestamptz ''2001-01-05'', timestamptz ''2001-01-07''); -- Should be unequal again PERFORM ut__eq(''For fun, unequal (distinct) intervals'',v_interval_id,v_interval_id_ck,false); @@ -422,7 +422,7 @@ PERFORM ut__overlaps_p(''Overlapping intervals'',v_interval_id,v_interval_id_ck,true); -- Ok, shift the dtart and end dates by one so that intervals do not overlap - PERFORM ut__shift(v_interval_id_ck,-1,-1,timestamp ''2001-01-04'', timestamp ''2001-01-06''); + PERFORM ut__shift(v_interval_id_ck,-1,-1,timestamptz ''2001-01-04'', timestamptz ''2001-01-06''); -- They should not overlap now. PERFORM ut__overlaps_p(''Non-overlapping intervals'',v_interval_id,v_interval_id_ck,false); @@ -432,84 +432,84 @@ -- Note that we are comparing with 2001-01-07 through 2001-01-08 PERFORM ut__overlaps_p(''Overlapping intervals'', v_interval_id, - timestamp ''2001-01-06'', - timestamp ''2001-01-09'', + timestamptz ''2001-01-06'', + timestamptz ''2001-01-09'', true); -- How about an interval next month? PERFORM ut__overlaps_p(''Non-overlapping intervals'', v_interval_id, - timestamp ''2001-02-06'', - timestamp ''2001-02-09'', + timestamptz ''2001-02-06'', + timestamptz ''2001-02-09'', false); -- Try a null starting interval PERFORM ut__overlaps_p(''Overlapping intervals (null start)'', v_interval_id, null, - timestamp ''2001-01-09'', + timestamptz ''2001-01-09'', true); -- Try a null starting interval PERFORM ut__overlaps_p(''Overlapping intervals (null end)'', v_interval_id, - timestamp ''2001-01-06'', + timestamptz ''2001-01-06'', null, true); -- What if the interval is not an allowable interval? -- By definition, any interval should be non-overlapping with a non-existent interval PERFORM ut__overlaps_p(''Non-overlapping intervals (non-allowed interval, outside month)'', v_interval_id, - timestamp ''2001-02-09'', - timestamp ''2001-02-06'', + timestamptz ''2001-02-09'', + timestamptz ''2001-02-06'', false); -- What if the interval is not an allowable interval? -- By definition, any interval should be non-overlapping with a non-existent interval PERFORM ut__overlaps_p(''Non-overlapping intervals (non-allowed interval, in month)'', v_interval_id, - timestamp ''2001-01-09'', - timestamp ''2001-01-06'', + timestamptz ''2001-01-09'', + timestamptz ''2001-01-06'', false); -- Yet another overloaded definition PERFORM ut__overlaps_p(''Overlapping intervals (not in time_intervals)'', - timestamp ''2001-01-06'', - timestamp ''2001-01-09'', - timestamp ''2001-01-07'', - timestamp ''2001-01-08'', + timestamptz ''2001-01-06'', + timestamptz ''2001-01-09'', + timestamptz ''2001-01-07'', + timestamptz ''2001-01-08'', true); -- Yet another overloaded definition PERFORM ut__overlaps_p(''Overlapping intervals (not in time_intervals)'', - timestamp ''2001-01-06'', - timestamp ''2001-01-09'', - timestamp ''2001-01-09'', - timestamp ''2001-01-10'', + timestamptz ''2001-01-06'', + timestamptz ''2001-01-09'', + timestamptz ''2001-01-09'', + timestamptz ''2001-01-10'', true); -- Yet another overloaded definition PERFORM ut__overlaps_p(''Overlapping intervals (not in time_intervals)'', - timestamp ''2001-01-06'', - timestamp ''2001-01-09'', + timestamptz ''2001-01-06'', + timestamptz ''2001-01-09'', null, - timestamp ''2001-01-10'', + timestamptz ''2001-01-10'', true); PERFORM ut__overlaps_p(''Overlapping intervals (not in time_intervals)'', - timestamp ''2001-01-06'', - timestamp ''2001-01-09'', - timestamp ''2001-01-10'', + timestamptz ''2001-01-06'', + timestamptz ''2001-01-09'', + timestamptz ''2001-01-10'', null, false); -- Yet another overloaded definition PERFORM ut__overlaps_p(''Non-overlapping intervals (not in time_intervals)'', - timestamp ''2001-02-06'', - timestamp ''2001-02-09'', - timestamp ''2001-01-07'', - timestamp ''2001-01-08'', + timestamptz ''2001-02-06'', + timestamptz ''2001-02-09'', + timestamptz ''2001-01-07'', + timestamptz ''2001-01-08'', false); Index: openacs-4/packages/acs-events/sql/postgresql/test/timespan-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/test/timespan-test.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/test/timespan-test.sql 13 Jul 2001 03:16:32 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/test/timespan-test.sql 2 Mar 2003 22:33:06 -0000 1.1.4.1 @@ -117,8 +117,8 @@ -- We test the creation of a time interval entry create function ut__new( - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' declare @@ -261,8 +261,8 @@ create function ut__join( integer, -- timespans.timespan_id%TYPE; - timestamp, -- time_intervals.start_date%TYPE; - timestamp -- time_intervals.end_date%TYPE; + timestamptz, -- time_intervals.start_date%TYPE; + timestamptz -- time_intervals.end_date%TYPE; ) returns integer as ' declare @@ -404,8 +404,8 @@ create function ut__overlaps_p( integer, -- timespans.timespan_id%TYPE; - timestamp, -- time_intervals.start_date%TYPE; - timestamp, -- time_intervals.end_date%TYPE; + timestamptz, -- time_intervals.start_date%TYPE; + timestamptz, -- time_intervals.end_date%TYPE; boolean ) returns integer as ' @@ -462,14 +462,14 @@ raise notice ''Regression test, part 1 (creates and edits).''; -- First create an interval - v_interval_id := time_interval__new(timestamp ''2001-01-01'',timestamp ''2001-01-20''); + v_interval_id := time_interval__new(timestamptz ''2001-01-01'',timestamptz ''2001-01-20''); --Check if creation of timespans work by supplying an interval id to be copied PERFORM ut__new(v_interval_id); -- We first check if the creation of timespans work -- This should be equivalent to what we have above - v_timespan_id := ut__new(timestamp ''2001-01-25'',timestamp ''2001-02-02''); + v_timespan_id := ut__new(timestamptz ''2001-01-25'',timestamptz ''2001-02-02''); -- Test if timespan exists PERFORM ut__exists_p(v_timespan_id,true); @@ -494,20 +494,20 @@ PERFORM ut__overlaps_interval_p(v_timespan_id,v_interval_id,true); -- A new timespans - v_timespan_id := ut__new(timestamp ''2001-03-05'',timestamp ''2001-03-31''); - v_timespan_id_ck := ut__new(timestamp ''2001-06-05'',timestamp ''2001-06-30''); + v_timespan_id := ut__new(timestamptz ''2001-03-05'',timestamptz ''2001-03-31''); + v_timespan_id_ck := ut__new(timestamptz ''2001-06-05'',timestamptz ''2001-06-30''); -- These timespans should not overlap PERFORM ut__overlaps_p(v_timespan_id,v_timespan_id_ck,false); -- Check overlaps against these known dates - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-02-06'',timestamp ''2001-03-25'',true); - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-03-07'',timestamp ''2001-04-01'',true); - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-01-01'',timestamp ''2001-03-20'',true); - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-01-01'',null,true); - PERFORM ut__overlaps_p(v_timespan_id,null,timestamp ''2001-04-01'',true); - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-04-01'',timestamp ''2001-04-30'',false); - PERFORM ut__overlaps_p(v_timespan_id,timestamp ''2001-02-01'',timestamp ''2001-02-27'',false); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-02-06'',timestamptz ''2001-03-25'',true); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-03-07'',timestamptz ''2001-04-01'',true); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-01-01'',timestamptz ''2001-03-20'',true); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-01-01'',null,true); + PERFORM ut__overlaps_p(v_timespan_id,null,timestamptz ''2001-04-01'',true); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-04-01'',timestamptz ''2001-04-30'',false); + PERFORM ut__overlaps_p(v_timespan_id,timestamptz ''2001-02-01'',timestamptz ''2001-02-27'',false); -- Join the first interval with the second, making a copy @@ -520,7 +520,7 @@ PERFORM ut__overlaps_p(v_timespan_id,v_timespan_id_ck,true); -- Join an interval instead - PERFORM ut__join(v_timespan_id_ck,timestamp ''2001-12-01'',timestamp ''2001-12-31''); + PERFORM ut__join(v_timespan_id_ck,timestamptz ''2001-12-01'',timestamptz ''2001-12-31''); -- Copy a timespan (will only contain two) PERFORM ut__copy(v_timespan_id,interval ''0 days''); Index: openacs-4/packages/acs-events/sql/postgresql/test/utest-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/test/utest-create.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-events/sql/postgresql/test/utest-create.sql 13 Jul 2001 03:16:32 -0000 1.1 +++ openacs-4/packages/acs-events/sql/postgresql/test/utest-create.sql 2 Mar 2003 22:33:06 -0000 1.1.4.1 @@ -223,8 +223,8 @@ create function ut_assert__eq ( varchar, - timestamp, - timestamp, + timestamptz, + timestamptz, boolean, boolean ) @@ -255,8 +255,8 @@ -- Overload for calls with default values create function ut_assert__eq ( varchar, -- IN VARCHAR2, - timestamp, - timestamp + timestamptz, + timestamptz ) returns integer as ' declare Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v diff -u -r1.6.4.3 -r1.6.4.4 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 11 Feb 2003 17:04:24 -0000 1.6.4.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 2 Mar 2003 22:33:33 -0000 1.6.4.4 @@ -20,7 +20,7 @@ objects like the site-wide organization, and the all users party. '; -create function acs__add_user (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,varchar) +create function acs__add_user (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,varchar) returns integer as ' declare user_id alias for $1; -- default null Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql 28 Apr 2001 17:35:30 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql 2 Mar 2003 22:33:33 -0000 1.3.4.1 @@ -14,7 +14,7 @@ log_id integer constraint acs_logs_pk primary key, - log_date timestamp default now() not null, + log_date timestamptz default current_timestamp not null, log_level varchar(20) not null constraint acs_logs_log_level_ck check (log_level in ('notice', 'warn', 'error', Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v diff -u -r1.35.2.3 -r1.35.2.4 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 13 Feb 2003 22:32:14 -0000 1.35.2.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 2 Mar 2003 22:33:33 -0000 1.35.2.4 @@ -182,9 +182,9 @@ references acs_objects(object_id), security_inherit_p boolean default 't' not null, creation_user integer, - creation_date timestamp default now() not null, + creation_date timestamptz default current_timestamp not null, creation_ip varchar(50), - last_modified timestamp default now() not null, + last_modified timestamptz default current_timestamp not null, modifying_user integer, modifying_ip varchar(50), tree_sortkey varbit, @@ -592,7 +592,7 @@ -- function new -create function acs_object__new (integer,varchar,timestamp with time zone,integer,varchar,integer,boolean) +create function acs_object__new (integer,varchar,timestamptz,integer,varchar,integer,boolean) returns integer as ' declare new__object_id alias for $1; -- default null @@ -603,7 +603,7 @@ new__context_id alias for $6; -- default null new__security_inherit_p alias for $7; -- default ''t'' v_object_id acs_objects.object_id%TYPE; - v_creation_date timestamp; + v_creation_date timestamptz; begin if new__object_id is null then select acs_object_id_seq.nextval @@ -633,7 +633,7 @@ end;' language 'plpgsql'; -- function new -create function acs_object__new (integer,varchar,timestamp with time zone,integer,varchar,integer) +create function acs_object__new (integer,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare new__object_id alias for $1; -- default null @@ -643,7 +643,7 @@ new__creation_ip alias for $5; -- default null new__context_id alias for $6; -- default null v_object_id acs_objects.object_id%TYPE; - v_creation_date timestamp; + v_creation_date timestamptz; begin if new__object_id is null then select acs_object_id_seq.nextval @@ -1348,13 +1348,13 @@ return acs_object__update_last_modified(acs_object__update_last_modified__object_id, now()); end;' language 'plpgsql'; -create function acs_object__update_last_modified (integer, timestamp with time zone) +create function acs_object__update_last_modified (integer, timestamptz) returns integer as ' declare acs_object__update_last_modified__object_id alias for $1; acs_object__update_last_modified__last_modified alias for $2; -- default now() v_parent_id integer; - v_last_modified timestamp; + v_last_modified timestamptz; begin if acs_object__update_last_modified__last_modified is null then v_last_modified := now(); Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -r1.29.2.2 -r1.29.2.3 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 21 Jan 2003 13:46:20 -0000 1.29.2.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 2 Mar 2003 22:33:33 -0000 1.29.2.3 @@ -267,7 +267,7 @@ constraint apm_package_vers_desc_for_ck check (description_format in ('text/html', 'text/plain')), description text, - release_date timestamp, + release_date timestamptz, vendor varchar(500), vendor_uri varchar(1500), enabled_p boolean default 'f' @@ -281,8 +281,8 @@ data_model_loaded_p boolean default 'f' constraint apm_package_vers_dml_p_nn not null, cvs_import_results text, - activation_date timestamp, - deactivation_date timestamp, + activation_date timestamptz, + deactivation_date timestamptz, -- FIXME: store the tarball in the content-repository -- distribution_tarball blob, item_id integer, @@ -292,7 +292,7 @@ -- references cr_items(item_id), content_length integer, distribution_uri varchar(1500), - distribution_date timestamp, + distribution_date timestamptz, constraint apm_package_vers_id_name_un unique(package_key, version_name) ); @@ -1636,7 +1636,7 @@ -- function new -create function apm_package__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer) +create function apm_package__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare new__package_id alias for $1; -- default null @@ -1864,7 +1864,7 @@ end;' language 'plpgsql'; -- create or replace package body apm_package_version -create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,boolean,boolean) returns integer as ' +create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,boolean,boolean) returns integer as ' declare apm_pkg_ver__version_id alias for $1; -- default null apm_pkg_ver__package_key alias for $2; @@ -2015,7 +2015,7 @@ -- function edit -create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,boolean,boolean) +create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,boolean,boolean) returns integer as ' declare edit__new_version_id alias for $1; -- default null @@ -2559,7 +2559,7 @@ -- function new -create function apm_application__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer) +create function apm_application__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare application_id alias for $1; -- default null @@ -2609,7 +2609,7 @@ -- create or replace package body apm_service -- function new -create function apm_service__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer) +create function apm_service__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare service_id alias for $1; -- default null Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-drop.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-drop.sql 9 May 2001 22:32:25 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-drop.sql 2 Mar 2003 22:33:34 -0000 1.2.4.1 @@ -80,7 +80,7 @@ drop function apm__set_value (integer,integer,varchar); drop function apm__set_value (integer,varchar,varchar); drop function apm_package__initialize_parameters (integer,varchar); -drop function apm_package__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer); +drop function apm_package__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer); drop function apm_package__delete (integer); drop function apm_package__initial_install_p (varchar); drop function apm_package__singleton_p (varchar); @@ -89,12 +89,12 @@ drop function apm_package__enable (integer); drop function apm_package__disable (integer); drop function apm_package__highest_version (varchar); -drop function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamp,varchar,varchar,boolean,boolean); +drop function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,boolean,boolean); drop function apm_package_version__delete (integer); drop function apm_package_version__enable (integer); drop function apm_package_version__disable (integer); drop function apm_package_version__copy (integer,integer,varchar,varchar); -drop function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamp,varchar,varchar,boolean,boolean); +drop function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,boolean,boolean); drop function apm_package_version__add_file (integer,integer,varchar,varchar, varchar); drop function apm_package_version__remove_file (integer,varchar); drop function apm_package_version__add_interface (integer,integer,varchar,varchar); @@ -113,9 +113,9 @@ drop function apm_package_type__num_parameters (varchar); drop function apm_parameter_value__new (integer,integer,integer,varchar); drop function apm_parameter_value__delete (integer); -drop function apm_application__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer); +drop function apm_application__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer); drop function apm_application__delete (integer); -drop function apm_service__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer); +drop function apm_service__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer); drop function apm_service__delete (integer); \t Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v diff -u -r1.9.2.2 -r1.9.2.3 --- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 15 Feb 2003 03:25:02 -0000 1.9.2.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 2 Mar 2003 22:33:34 -0000 1.9.2.3 @@ -269,7 +269,7 @@ -- PARTY PACKAGE -- ------------------- -create function party__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,integer) +create function party__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,integer) returns integer as ' declare new__party_id alias for $1; -- default null @@ -391,7 +391,7 @@ -- create or replace package body person -- function new select define_function_args('person__new','person_id,object_type;person,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,context_id'); -create function person__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,integer) +create function person__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,integer) returns integer as ' declare new__person_id alias for $1; -- default null @@ -503,9 +503,9 @@ priv_email integer default 5 not null, email_verified_p boolean default 't', email_bouncing_p boolean default 'f' not null, - no_alerts_until timestamp, - last_visit timestamp, - second_to_last_visit timestamp, + no_alerts_until timestamptz, + last_visit timestamptz, + second_to_last_visit timestamptz, n_sessions integer default 1 not null, password_question varchar(1000), password_answer varchar(1000) @@ -628,7 +628,7 @@ select define_function_args('user__new','user_id,object_type;user,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,password,salt,password_question,password_answer,screen_name,email_verified_p;t,context_id'); -create function acs_user__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer) +create function acs_user__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer) returns integer as ' declare new__user_id alias for $1; -- default null Index: openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql,v diff -u -r1.3.4.1 -r1.3.4.2 --- openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql 21 Jan 2003 13:46:20 -0000 1.3.4.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql 2 Mar 2003 22:33:34 -0000 1.3.4.2 @@ -88,7 +88,7 @@ -- create or replace package body journal_entry -- function new -create function journal_entry__new (integer,integer,varchar,varchar,timestamp with time zone,integer,varchar,varchar) +create function journal_entry__new (integer,integer,varchar,varchar,timestamptz,integer,varchar,varchar) returns integer as ' declare new__journal_id alias for $1; -- default null Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql,v diff -u -r1.8.2.1 -r1.8.2.2 --- openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql 21 Jan 2003 13:46:20 -0000 1.8.2.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql 2 Mar 2003 22:33:34 -0000 1.8.2.2 @@ -15,7 +15,7 @@ ------------------ -- rel_segment__new -- full version -create function rel_segment__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,integer,varchar,integer) +create function rel_segment__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,integer,varchar,integer) returns integer as ' declare new__segment_id alias for $1; -- default null Index: openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql 19 Dec 2001 18:33:22 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql 2 Mar 2003 22:33:34 -0000 1.4.4.1 @@ -35,7 +35,7 @@ token_id integer constraint secret_tokens_token_id_pk primary key, token char(40), - token_timestamp timestamp + token_timestamp timestamptz ); create sequence t_sec_security_token_id_seq cache 100; Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql,v diff -u -r1.3.4.2 -r1.3.4.3 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql 3 Feb 2003 16:13:25 -0000 1.3.4.2 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql 2 Mar 2003 22:34:06 -0000 1.3.4.3 @@ -176,7 +176,7 @@ body_from integer constraint acs_mail_bodies_body_from_fk references parties on delete set null, - body_date timestamp, + body_date timestamptz, header_message_id varchar(1000) constraint acs_mail_bodies_h_m_id_un unique Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-drop.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-drop.sql 13 Aug 2001 17:29:54 -0000 1.2 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-drop.sql 2 Mar 2003 22:34:06 -0000 1.2.4.1 @@ -11,7 +11,7 @@ \i acs-mail-nt-drop.sql drop function acs_mail_queue_message__new (integer,integer, - integer,timestamp,integer,varchar,varchar); + integer,timestamptz,integer,varchar,varchar); drop function acs_mail_queue_message__delete (integer); drop table acs_mail_queue_incoming; @@ -24,22 +24,22 @@ ); -drop function acs_mail_gc_object__new (integer,varchar,timestamp,integer, +drop function acs_mail_gc_object__new (integer,varchar,timestamptz,integer, varchar,integer); drop function acs_mail_gc_object__delete(integer); -drop function acs_mail_body__new (integer,integer,integer,timestamp,varchar, +drop function acs_mail_body__new (integer,integer,integer,timestamptz,varchar, varchar,text,text,text,integer,varchar,date,integer,varchar,integer); drop function acs_mail_body__delete(integer); drop function acs_mail_body__body_p(integer); -drop function acs_mail_body__clone (integer,integer,varchar,timestamp, +drop function acs_mail_body__clone (integer,integer,varchar,timestamptz, integer,varchar,integer); drop function acs_mail_body__set_content_object (integer,integer); drop function acs_mail_multipart__new (integer,varchar,varchar, - timestamp,integer,varchar,integer); + timestamptz,integer,varchar,integer); drop function acs_mail_multipart__delete (integer); drop function acs_mail_multipart__multipart_p (integer); drop function acs_mail_multipart__add_content (integer,integer); -drop function acs_mail_link__new (integer,integer,integer,timestamp, +drop function acs_mail_link__new (integer,integer,integer,timestamptz, integer,varchar,varchar); drop function acs_mail_link__delete (integer); drop function acs_mail_link__link_p (integer); Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql,v diff -u -r1.3.4.1 -r1.3.4.2 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql 21 Jan 2003 13:46:56 -0000 1.3.4.1 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql 2 Mar 2003 22:34:06 -0000 1.3.4.2 @@ -8,7 +8,7 @@ -- Package Implementations --------------------------------------------- -create function acs_mail_gc_object__new (integer,varchar,timestamp with time zone,integer,varchar,integer) +create function acs_mail_gc_object__new (integer,varchar,timestamptz,integer,varchar,integer) returns integer as ' declare p_gc_object_id alias for $1; -- default null @@ -51,7 +51,7 @@ -- first create a CR item. -- then call acs_mail_body__new with the CR item's item_id -create function acs_mail_body__new (integer,integer,integer,timestamp with time zone,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer) +create function acs_mail_body__new (integer,integer,integer,timestamptz,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer) returns integer as ' declare p_body_id alias for $1; -- default null @@ -136,7 +136,7 @@ end; ' language 'plpgsql'; -create function acs_mail_body__clone (integer,integer,varchar,timestamp with time zone, +create function acs_mail_body__clone (integer,integer,varchar,timestamptz, integer,varchar,integer) returns integer as ' declare @@ -150,7 +150,7 @@ v_object_id integer; v_body_reply_to integer; v_body_from integer; - v_body_date timestamp; + v_body_date timestamptz; v_header_message_id varchar; v_header_reply_to varchar; v_header_subject text; @@ -205,7 +205,7 @@ ---- --create or replace package body acs_mail_multipart create function acs_mail_multipart__new (integer,varchar,varchar, -timestamp,integer,varchar,integer) +timestamptz,integer,varchar,integer) returns integer as ' declare p_multipart_id alias for $1; -- default null, @@ -296,7 +296,7 @@ --end acs_mail_multipart; --create or replace package body acs_mail_link__ -create function acs_mail_link__new (integer,integer,integer,timestamp with time zone,integer,varchar,varchar) +create function acs_mail_link__new (integer,integer,integer,timestamptz,integer,varchar,varchar) returns integer as ' declare p_mail_link_id alias for $1; -- default null Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql,v diff -u -r1.5.2.2 -r1.5.2.3 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql 21 Jan 2003 13:46:56 -0000 1.5.2.2 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-queue-create.sql 2 Mar 2003 22:34:06 -0000 1.5.2.3 @@ -49,7 +49,7 @@ -- API ----------------------------------------------------------------- --create or replace package body acs_mail_queue_message__ -create function acs_mail_queue_message__new (integer,integer,integer,timestamp with time zone,integer,varchar,varchar) +create function acs_mail_queue_message__new (integer,integer,integer,timestamptz,integer,varchar,varchar) returns integer as ' declare p_mail_link_id alias for $1; -- default null Index: openacs-4/packages/acs-mail/tcl/acs-mail-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/tcl/acs-mail-procs-postgresql.xql,v diff -u -r1.9 -r1.9.2.1 --- openacs-4/packages/acs-mail/tcl/acs-mail-procs-postgresql.xql 22 Apr 2002 04:19:40 -0000 1.9 +++ openacs-4/packages/acs-mail/tcl/acs-mail-procs-postgresql.xql 2 Mar 2003 22:34:40 -0000 1.9.2.1 @@ -11,7 +11,7 @@ null::integer, -- new__parent_id null::integer, -- new__item_id null::varchar, -- new__locale - now()::timestamp, -- new__creation_date + current_timestamp, -- new__creation_date :creation_user::integer, -- new__creation_user null::integer, -- new__context_id :creation_ip::varchar, -- new__creation_ip Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql,v diff -u -r1.8.4.1 -r1.8.4.2 --- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql 21 Jan 2003 13:47:08 -0000 1.8.4.1 +++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql 2 Mar 2003 22:35:07 -0000 1.8.4.2 @@ -50,7 +50,7 @@ reply_to integer constraint acs_messages_reply_to_fk references acs_messages (message_id) on delete set null, - sent_date timestamp + sent_date timestamptz constraint acs_messages_sent_date_nn not null, sender integer @@ -189,7 +189,7 @@ constraint amo_to_address_nn not null, grouping_id integer, - wait_until timestamp + wait_until timestamptz constraint amo_wait_until_nn not null, constraint acs_messages_outgoing_pk primary key (message_id, to_address) Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql 5 Jul 2001 21:11:37 -0000 1.3 +++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql 2 Mar 2003 22:35:07 -0000 1.3.4.1 @@ -13,30 +13,30 @@ drop function acs_message_update_tr(); drop function acs_message__edit (integer,varchar,varchar,varchar, - text,integer,timestamp,integer,varchar,boolean); -drop function acs_message__new (integer,integer,timestamp,integer, + text,integer,timestamptz,integer,varchar,boolean); +drop function acs_message__new (integer,integer,timestamptz,integer, varchar,varchar,varchar,varchar,varchar,text, integer,integer,integer,varchar,varchar,boolean); drop function acs_message__delete (integer); drop function acs_message__message_p (integer); -drop function acs_message__send (integer,varchar,integer,timestamp); -drop function acs_message__send (integer,integer,integer,timestamp); +drop function acs_message__send (integer,varchar,integer,timestamptz); +drop function acs_message__send (integer,integer,integer,timestamptz); drop function acs_message__first_ancestor (integer); drop function acs_message__new_file (integer,integer,varchar,varchar, - text,varchar,text,timestamp,integer, + text,varchar,text,timestamptz,integer, varchar,boolean); drop function acs_message__edit_file (integer,varchar,text,varchar, - text,timestamp,integer,varchar,boolean); + text,timestamptz,integer,varchar,boolean); drop function acs_message__delete_file (integer); drop function acs_message__new_image (integer,integer,varchar,varchar, text,varchar,text,integer,integer, - timestamp,integer,varchar,boolean); + timestamptz,integer,varchar,boolean); drop function acs_message__edit_image (integer,varchar,text,varchar, - text,integer,integer,timestamp,integer, + text,integer,integer,timestamptz,integer, varchar,boolean); drop function acs_message__delete_image (integer); drop function acs_message__new_extlink (varchar,integer,varchar,varchar,text, - integer,timestamp,integer,varchar); + integer,timestamptz,integer,varchar); drop function acs_message__edit_extlink (integer,varchar,varchar,text); drop function acs_message__delete_extlink (integer); drop function acs_message__name (integer); Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql,v diff -u -r1.10.4.1 -r1.10.4.2 --- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql 21 Jan 2003 13:47:08 -0000 1.10.4.1 +++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql 2 Mar 2003 22:35:07 -0000 1.10.4.2 @@ -11,7 +11,7 @@ -- create function acs_message__edit (integer,varchar,varchar,varchar, -text,integer,timestamp with time zone,integer,varchar,boolean) +text,integer,timestamptz,integer,varchar,boolean) returns integer as ' declare p_message_id alias for $1; @@ -74,7 +74,7 @@ -- Jon Griffin 05-21-2001 ---------------- -create function acs_message__new (integer,integer,timestamp with time zone,integer, +create function acs_message__new (integer,integer,timestamptz,integer, varchar,varchar,varchar,varchar,varchar,text,integer,integer,integer, varchar,varchar,boolean) returns integer as ' @@ -91,7 +91,7 @@ p_data alias for $10; --default null, p_parent_id alias for $11; --default 0, p_context_id alias for $12; - p_creation_date timestamp := current_timestamp; -- alias for $13 --default sysdate, + p_creation_date timestamptz := current_timestamp; -- alias for $13 --default sysdate, p_creation_user alias for $13; --default null, p_creation_ip alias for $14; --default null, p_object_type alias for $15; --default ''acs_message'', @@ -194,14 +194,14 @@ end if; end;' language 'plpgsql'; -create function acs_message__send (integer,varchar,integer,timestamp with time zone) +create function acs_message__send (integer,varchar,integer,timestamptz) returns integer as ' declare p_message_id alias for $1; p_to_address alias for $2; p_grouping_id alias for $3; -- default null p_wait_until alias for $4; -- default sysdate - v_wait_until timestamp; + v_wait_until timestamptz; begin v_wait_until := coalesce(p_wait_until, current_timestamp); insert into acs_messages_outgoing @@ -211,14 +211,14 @@ return 1; end;' language 'plpgsql'; -create function acs_message__send (integer,integer,integer,timestamp with time zone) +create function acs_message__send (integer,integer,integer,timestamptz) returns integer as ' declare p_message_id alias for $1; p_recipient_id alias for $2; p_grouping_id alias for $3; -- default null p_wait_until alias for $4; -- default sysdate - v_wait_until timestamp; + v_wait_until timestamptz; begin v_wait_until := coalesce (p_wait_until, current_timestamp); insert into acs_messages_outgoing @@ -258,7 +258,7 @@ -- by direct calls to CR code in the near future. create function acs_message__new_file (integer,integer,varchar,varchar, -text,varchar,integer,timestamp,integer,varchar,boolean,varchar) +text,varchar,integer,timestamptz,integer,varchar,boolean,varchar) returns integer as ' declare p_message_id alias for $1; @@ -312,7 +312,7 @@ end;' language 'plpgsql'; create function acs_message__edit_file (integer,varchar,text,varchar, -integer,timestamp,integer,varchar,boolean) +integer,timestamptz,integer,varchar,boolean) returns integer as ' declare p_file_id alias for $1; @@ -358,7 +358,7 @@ end;' language 'plpgsql'; create function acs_message__new_image (integer,integer,varchar,varchar, -text,varchar,integer,integer,integer,timestamp,integer,varchar,boolean,varchar) +text,varchar,integer,integer,integer,timestamptz,integer,varchar,boolean,varchar) returns integer as ' declare p_message_id alias for $1; @@ -416,7 +416,7 @@ end;' language 'plpgsql'; create function acs_message__edit_image (integer,varchar,text,varchar, -integer,integer,integer,timestamp,integer,varchar,boolean) +integer,integer,integer,timestamptz,integer,varchar,boolean) returns integer as ' declare p_image_id alias for $1; @@ -476,7 +476,7 @@ -- XXX should just call content_extlink.new create function acs_message__new_extlink (varchar,integer,varchar, -varchar,text,integer,timestamp,integer,varchar) +varchar,text,integer,timestamptz,integer,varchar) returns integer as ' declare p_name alias for $1; -- default null Index: openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql,v diff -u -r1.7.4.1 -r1.7.4.2 --- openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql 28 Jan 2003 19:30:55 -0000 1.7.4.1 +++ openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql 2 Mar 2003 22:35:38 -0000 1.7.4.2 @@ -48,13 +48,13 @@ package_name varchar(100) constraint arr_package_name_uq unique, -- last updated - last_update timestamp, + last_update timestamptz, -- where is this data from source varchar(1000), source_url varchar(255), -- should default to today - effective_date timestamp, -- default sysdate - expiry_date timestamp, + effective_date timestamptz, -- default sysdate + expiry_date timestamptz, -- a text field to hold the maintainer maintainer_id integer constraint arr_maintainer_id_fk references persons(person_id), @@ -69,9 +69,9 @@ -- default for Oracle -create function acs_reference__new (integer,varchar,boolean,varchar,timestamp, -varchar,varchar,timestamp,timestamp,integer,integer,varchar,varchar, -integer,varchar,integer) +create function acs_reference__new (integer,varchar,boolean,varchar,timestamptz, +varchar,varchar,timestamptz,timestamptz,integer,integer,varchar,varchar, +varchar,varchar,integer) returns integer as ' declare p_repository_id alias for $1; -- default null @@ -150,8 +150,8 @@ ' language 'plpgsql'; -- made initially for PG -create function acs_reference__new (varchar,timestamp, -varchar,varchar,timestamp with time zone) +create function acs_reference__new (varchar,timestamptz, +varchar,varchar,timestamptz) returns integer as ' declare p_table_name alias for $1; -- Index: openacs-4/packages/acs-reference/sql/postgresql/acs-reference-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/postgresql/acs-reference-drop.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/packages/acs-reference/sql/postgresql/acs-reference-drop.sql 1 Sep 2001 20:34:19 -0000 1.2 +++ openacs-4/packages/acs-reference/sql/postgresql/acs-reference-drop.sql 2 Mar 2003 22:35:38 -0000 1.2.4.1 @@ -32,9 +32,9 @@ select acs_object_type__drop_type ('acs_reference_repository', 't'); -drop function acs_reference__new (varchar,timestamp, varchar,varchar,timestamp); -drop function acs_reference__new (integer,varchar,boolean,varchar,timestamp, -varchar,varchar,timestamp,timestamp,integer,integer,varchar,varchar, +drop function acs_reference__new (varchar,timestamptz, varchar,varchar,timestamptz); +drop function acs_reference__new (integer,varchar,boolean,varchar,timestamptz, +varchar,varchar,timestamptz,timestamptz,integer,integer,varchar,varchar, integer,varchar,integer); drop function acs_reference__delete (integer); drop function acs_reference__is_expired_p (integer); Index: openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql,v diff -u -r1.5.2.1 -r1.5.2.2 --- openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql 21 Jan 2003 13:47:21 -0000 1.5.2.1 +++ openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql 2 Mar 2003 22:36:17 -0000 1.5.2.2 @@ -38,7 +38,7 @@ select define_function_args('application_group__new','group_id,object_type;application_group,creation_date;now(),creation_user,creation_ip,email,url,group_name,package_id,context_id'); -create function application_group__new(integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,integer,integer) +create function application_group__new(integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,integer,integer) returns integer as ' declare new__group_id alias for $1; 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 -r1.4 -r1.4.4.1 --- openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 2 Sep 2001 17:06:29 -0000 1.4 +++ openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 2 Mar 2003 22:37:16 -0000 1.4.4.1 @@ -154,7 +154,7 @@ -- type_key integer, -- ab_contact_attr_types.type_id%TYPE varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE @@ -356,7 +356,7 @@ -- before_attr_id in ab_contact_attrs.attr_id%TYPE integer, -- ab_contact_attrs.attr_id%TYPE varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE @@ -596,7 +596,7 @@ -- category integer, -- ab_contacts.contact_id%TYPE default null, varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE Index: openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql 29 Aug 2001 00:52:20 -0000 1.3 +++ openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql 2 Mar 2003 22:37:16 -0000 1.3.4.1 @@ -19,7 +19,7 @@ drop function ab_contact_attr_type__new( integer, varchar, - timestamp, + timestamptz, integer, varchar, integer, @@ -30,7 +30,7 @@ drop function ab_contact_attr__new ( integer, varchar, - timestamp, + timestamptz, integer, varchar, integer, @@ -54,7 +54,7 @@ drop function ab_contact_rel__delete(integer); drop function ab_contact_rel__new(integer,integer,integer,integer,varchar,varchar,varchar); -drop function ab_contact__new( integer,varchar,timestamp,integer,varchar,integer,varchar,varchar,varchar,varchar,integer,varchar); +drop function ab_contact__new( integer,varchar,timestamptz,integer,varchar,integer,varchar,varchar,varchar,varchar,integer,varchar); drop function ab_contact__name( integer); drop function ab_contact__delete(integer, boolean); Index: openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql 26 Sep 2002 22:42:13 -0000 1.2 +++ openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql 2 Mar 2003 22:37:54 -0000 1.2.2.1 @@ -1,7 +1,7 @@ create table authorize_gateway_result_log ( transaction_id varchar(20) not null, txn_attempted_type varchar(18), - txn_attempted_time datetime, + txn_attempted_time timestamptz, response varchar(400), response_code varchar(1), response_reason_code varchar(2), Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql,v diff -u -r1.19.2.2 -r1.19.2.3 --- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 21 Jan 2003 13:48:32 -0000 1.19.2.2 +++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 2 Mar 2003 22:38:56 -0000 1.19.2.3 @@ -32,9 +32,9 @@ -- meta tags that could be looked up regularly meta_keywords text, meta_description text, - last_checked_date timestamp, + last_checked_date timestamptz, -- the last time the site returned a "live" status - last_live_date timestamp + last_live_date timestamptz ); create function inline_0 () @@ -84,7 +84,7 @@ constraint bm_bookmarks_parent_id_fk references acs_objects (object_id), -- When the bookmark was last clicked on - last_access_date timestamp, + last_access_date timestamptz, tree_sortkey varbit ); @@ -250,7 +250,7 @@ -- easily grow very large in big communities sharing bookmarks actively -- refers to whether a folder is open or closed closed_p boolean default 'f', - creation_date timestamp, + creation_date timestamptz, constraint bm_in_closed_p_pk primary key (bookmark_id, in_closed_p_id) ); @@ -347,7 +347,7 @@ END; ' LANGUAGE 'plpgsql'; -CREATE FUNCTION bookmark__new (integer,integer,integer,varchar,boolean,integer,timestamp with time zone,integer,varchar,integer) +CREATE FUNCTION bookmark__new (integer,integer,integer,varchar,boolean,integer,timestamptz,integer,varchar,integer) RETURNS integer AS ' DECLARE p_bookmark_id ALIAS FOR $1; -- in bm_bookmarks.bookmark_id%TYPE, Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-drop.sql,v diff -u -r1.2.4.1 -r1.2.4.2 --- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-drop.sql 13 Feb 2003 20:49:40 -0000 1.2.4.1 +++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-drop.sql 2 Mar 2003 22:38:56 -0000 1.2.4.2 @@ -75,7 +75,7 @@ -- (new, delete, name, get_in_closed_p, update_in_closed_p_one_user, update_in_closed_p_all_users, -- toggle_open_close, toggle_open_close_all, get_root_folder, new_root_folder, private_p, -- update_private_p, initialize_in_closed_p) -DROP FUNCTION bookmark__new (integer,integer,integer,varchar,boolean,integer,timestamp with time zone,integer,varchar,integer); +DROP FUNCTION bookmark__new (integer,integer,integer,varchar,boolean,integer,timestamptz,integer,varchar,integer); DROP FUNCTION bookmark__delete (integer); DROP FUNCTION bookmark__name (integer); DROP FUNCTION bookmark__get_in_closed_p (integer,integer); Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v diff -u -r1.5.2.1 -r1.5.2.2 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 4 Dec 2002 19:51:47 -0000 1.5.2.1 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 2 Mar 2003 22:39:33 -0000 1.5.2.2 @@ -326,8 +326,8 @@ actor integer not null constraint bt_bug_actions_actor_fk references users(user_id), - action_date timestamp not null - default now(), + action_date timestamptz not null + default current_timestamp, comment text, comment_format varchar(30) default 'plain' not null constraint bt_bug_actions_comment_format_ck @@ -599,8 +599,8 @@ actor integer not null constraint bt_patch_actions_actor_fk references users(user_id), - action_date timestamp not null - default now(), + action_date timestamptz not null + default current_timestamp, comment text, comment_format varchar(30) default 'plain' not null constraint bt_patch_actions_comment_format_ck Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d3-0.7d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d3-0.7d4.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d3-0.7d4.sql 29 Aug 2002 17:13:06 -0000 1.2 +++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d3-0.7d4.sql 2 Mar 2003 22:39:33 -0000 1.2.2.1 @@ -101,8 +101,8 @@ actor integer not null constraint bt_bug_actions_actor_fk references users(user_id), - action_date timestamp not null - default now(), + action_date timestamptz not null + default current_timestamp, comment text, comment_format varchar(30) default 'plain' not null constraint bt_bug_actions_comment_format_ck Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d5-0.8.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d5-0.8.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d5-0.8.sql 11 Sep 2002 14:03:22 -0000 1.1 +++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-0.7d5-0.8.sql 2 Mar 2003 22:39:33 -0000 1.1.2.1 @@ -52,8 +52,8 @@ actor integer not null constraint bt_patch_actions_actor_fk references users(user_id), - action_date timestamp not null - default now(), + action_date timestamptz not null + default current_timestamp, comment text, comment_format varchar(30) default 'plain' not null constraint bt_patch_actions_comment_format_ck Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-create.sql,v diff -u -r1.2.2.2 -r1.2.2.3 --- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-create.sql 6 Dec 2002 12:42:14 -0000 1.2.2.2 +++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-create.sql 2 Mar 2003 22:40:01 -0000 1.2.2.3 @@ -7,7 +7,7 @@ select define_function_args('bulk_mail__new','bulk_mail_id,package_id,send_date,date_format,sent_p;f,from_addr,subject,reply_to,extra_headers,message,query,creation_date;now(),creation_user,creation_ip,context_id'); -create function bulk_mail__new (integer, integer, varchar, varchar, varchar, varchar, varchar, varchar, varchar, text, varchar, timestamp, integer, varchar, integer) +create function bulk_mail__new (integer, integer, varchar, varchar, varchar, varchar, varchar, varchar, varchar, text, varchar, timestamptz, integer, varchar, integer) returns integer as ' declare bulk_mail__new__bulk_mail_id alias for $1; -- default to null Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-drop.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-drop.sql 12 Jun 2002 13:53:13 -0000 1.2 +++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-package-drop.sql 2 Mar 2003 22:40:01 -0000 1.2.2.1 @@ -5,5 +5,5 @@ -- @version $Id$ -- -drop function bulk_mail__new (integer, integer, varchar, varchar, varchar, varchar, varchar, varchar, varchar, text, varchar, timestamp, integer, varchar, integer); +drop function bulk_mail__new (integer, integer, varchar, varchar, varchar, varchar, varchar, varchar, varchar, text, varchar, timestamptz, integer, varchar, integer); drop function bulk_mail__delete (integer); Index: openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql 22 Jul 2002 21:46:19 -0000 1.10 +++ openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql 2 Mar 2003 22:40:32 -0000 1.10.2.1 @@ -113,7 +113,7 @@ integer, -- recurrence_id acs_events.recurrence_id%TYPE varchar, -- object_type acs_objects.object_type%TYPE integer, -- context_id acs_objects.context_id%TYPE - timestamp, -- createion_date acs_objects.creation_date%TYPE + timestamptz,-- creation_date acs_objects.creation_date%TYPE integer, -- creation_user acs_objects.creation_user%TYPE varchar -- creation_ip acs_objects.creation_ip%TYPE ) Index: openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql 8 Mar 2002 22:29:24 -0000 1.4 +++ openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql 2 Mar 2003 22:40:32 -0000 1.4.4.1 @@ -25,7 +25,7 @@ integer, varchar, integer, - timestamp, + timestamptz, integer, varchar ); Index: openacs-4/packages/calendar/sql/postgresql/calendar-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/calendar-create.sql,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/calendar/sql/postgresql/calendar-create.sql 21 Aug 2002 15:28:55 -0000 1.10 +++ openacs-4/packages/calendar/sql/postgresql/calendar-create.sql 2 Mar 2003 22:40:32 -0000 1.10.2.1 @@ -284,7 +284,7 @@ boolean, -- calendar.private_p integer, -- calendar.package_id integer, -- acs_objects.context_id%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar -- acs_objects.creation_ip%TYPE ) @@ -443,7 +443,7 @@ CREATE FUNCTION calendar__month_name( - timestamp + timestamptz ) RETURNS varchar AS 'declare @@ -461,12 +461,12 @@ CREATE FUNCTION calendar__next_month( - timestamp + timestamptz ) -RETURNS timestamp +RETURNS timestamptz AS 'declare next_month__current_dates alias for $1; - v_date timestamp; + v_date timestamptz; begin --select trunc(add_months(to_date(db_sysdate), -1)) select date_trunc(''day'', current_timestamp + cast(''1 month'' as interval)) @@ -479,9 +479,9 @@ CREATE FUNCTION calendar__prev_month( - timestamp + timestamptz ) -RETURNS timestamp +RETURNS timestamptz AS 'declare prev_month__current_date alias for $1; v_date date; @@ -497,7 +497,7 @@ CREATE FUNCTION calendar__num_day_in_month( - timestamp + timestamptz ) RETURNS integer AS 'declare @@ -514,12 +514,12 @@ CREATE FUNCTION calendar__first_displayed_date( - timestamp + timestamptz ) -RETURNS timestamp +RETURNS timestamptz AS 'declare first_displayed_date__current_date alias for $1; - v_date timestamp; + v_date timestamptz; begin select next_day(date_trunc(''Month'', current_date) - 7 , ''SUNDAY'') into v_date @@ -531,12 +531,12 @@ CREATE FUNCTION calendar__last_displayed_date( - timestamp + timestamptz ) -RETURNS timestamp +RETURNS timestamptz AS 'declare last_displayed_date__current_date alias for $1; - v_date timestamp; + v_date timestamptz; begin select next_day(last_day(current_date), ''SATURDAY'') into v_date Index: openacs-4/packages/calendar/sql/postgresql/calendar-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/calendar-drop.sql,v diff -u -r1.5 -r1.5.4.1 --- openacs-4/packages/calendar/sql/postgresql/calendar-drop.sql 27 Sep 2001 04:12:20 -0000 1.5 +++ openacs-4/packages/calendar/sql/postgresql/calendar-drop.sql 2 Mar 2003 22:40:32 -0000 1.5.4.1 @@ -140,7 +140,7 @@ boolean, -- calendar.private_p integer, -- calendar.package_id integer, -- acs_objects.context_id%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar -- acs_objects.creation_ip%TYPE ); @@ -168,27 +168,27 @@ ); DROP FUNCTION calendar__month_name( - timestamp + timestamptz ); DROP FUNCTION calendar__next_month( - timestamp + timestamptz ); DROP FUNCTION calendar__prev_month( - timestamp + timestamptz ); DROP FUNCTION calendar__num_day_in_month( - timestamp + timestamptz ); DROP FUNCTION calendar__first_displayed_date( - timestamp + timestamptz ); DROP FUNCTION calendar__last_displayed_date( - timestamp + timestamptz ); -- drop table Index: openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/cal-item-2-procs-postgresql.xql,v diff -u -r1.5.2.1 -r1.5.2.2 --- openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql 7 Feb 2003 02:49:22 -0000 1.5.2.1 +++ openacs-4/packages/calendar/tcl/cal-item-2-procs-postgresql.xql 2 Mar 2003 22:41:11 -0000 1.5.2.2 @@ -5,7 +5,7 @@ - select CASE WHEN (:start_date::timestamp - :end_date::timestamp) <= 0 + select CASE WHEN :start_date::timestamptz <= :end_date::timestamptz THEN 1 ELSE -1 END Index: openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql,v diff -u -r1.12.2.1 -r1.12.2.2 --- openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql 2 Oct 2002 11:28:45 -0000 1.12.2.1 +++ openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql 2 Mar 2003 22:41:11 -0000 1.12.2.2 @@ -25,8 +25,8 @@ select timespan__new ( - :start_date::timestamp, - :end_date::timestamp + :start_date::timestamptz, + :end_date::timestamptz ) @@ -60,8 +60,8 @@ select time_interval__edit ( :interval_id, - :start_date::timestamp, - :end_date::timestamp + :start_date::timestamptz, + :end_date::timestamptz ) Index: openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-oracle.xql,v diff -u -r1.11 -r1.11.2.1 --- openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql 25 Jul 2002 03:15:32 -0000 1.11 +++ openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql 2 Mar 2003 22:41:11 -0000 1.11.2.1 @@ -40,7 +40,7 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')) + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'SUNDAY')) as sunday_of_the_week, to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday')) as saturday_of_the_week Index: openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-postgresql.xql,v diff -u -r1.7 -r1.7.2.1 --- openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql 25 Jul 2002 03:20:24 -0000 1.7 +++ openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql 2 Mar 2003 22:41:11 -0000 1.7.2.1 @@ -39,7 +39,7 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')- '1 week'::timespan, 'Sunday'), 'YYYY-MM-DD') + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')- '1 week'::interval, 'Sunday'), 'YYYY-MM-DD') as sunday_of_the_week, to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday'), 'YYYY-MM-DD') as saturday_of_the_week Index: openacs-4/packages/calendar/www/cal-weekview-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview-oracle.xql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/packages/calendar/www/cal-weekview-oracle.xql 16 Oct 2001 18:18:36 -0000 1.3 +++ openacs-4/packages/calendar/www/cal-weekview-oracle.xql 2 Mar 2003 22:41:37 -0000 1.3.4.1 @@ -8,7 +8,7 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')) + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'SUNDAY')) as sunday_of_the_week, to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday')) as saturday_of_the_week Index: openacs-4/packages/calendar/www/cal-weekview-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview-postgresql.xql,v diff -u -r1.6 -r1.6.4.1 --- openacs-4/packages/calendar/www/cal-weekview-postgresql.xql 16 Oct 2001 18:18:36 -0000 1.6 +++ openacs-4/packages/calendar/www/cal-weekview-postgresql.xql 2 Mar 2003 22:41:37 -0000 1.6.4.1 @@ -8,9 +8,9 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY'), 'YYYY-MM-DD') + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') - cast(7 as interval), 'SUNDAY'), 'YYYY-MM-DD') as sunday_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')+7, 'Saturday'), 'YYYY-MM-DD') + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd') + cast(7 as interval), 'Saturday'), 'YYYY-MM-DD') as saturday_of_the_week from dual Index: openacs-4/packages/cms/sql/postgresql/cms-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/postgresql/cms-create.sql,v diff -u -r1.5.4.3 -r1.5.4.4 --- openacs-4/packages/cms/sql/postgresql/cms-create.sql 11 Feb 2003 17:07:33 -0000 1.5.4.3 +++ openacs-4/packages/cms/sql/postgresql/cms-create.sql 2 Mar 2003 22:42:10 -0000 1.5.4.4 @@ -179,7 +179,7 @@ end;' language 'plpgsql'; -- function new -create or replace function content_module__new (varchar,varchar,varchar,integer,integer,integer,timestamp with time zone,integer,varchar,varchar) +create or replace function content_module__new (varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar,varchar) returns integer as ' declare p_name alias for $1; Index: openacs-4/packages/cms/sql/postgresql/cms-workflow.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/postgresql/cms-workflow.sql,v diff -u -r1.11.4.2 -r1.11.4.3 --- openacs-4/packages/cms/sql/postgresql/cms-workflow.sql 11 Feb 2003 17:07:33 -0000 1.11.4.2 +++ openacs-4/packages/cms/sql/postgresql/cms-workflow.sql 2 Mar 2003 22:42:10 -0000 1.11.4.3 @@ -540,7 +540,7 @@ -- procedure checkout -create or replace function content_workflow__checkout (integer,timestamp with time zone,integer,varchar,varchar) +create or replace function content_workflow__checkout (integer,timestamptz,integer,varchar,varchar) returns integer as ' declare p_task_id alias for $1;