• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
PG 9.0 compatibility. Changes regarding usage of sequences. Deleting unused views and sequences.

    • -0
    • +149
    ./postgresql/upgrade/upgrade-0.6d3-0.6d4.sql
  1. … 1 more file in changeset.
More fixes to timespan calculaton to handle timezone (DST) spanning recurring events.

  1. … 1 more file in changeset.
Fix problem with Daylight Saving Time when creating recurring

events. This works fine in Oracle because the timestamps don't have

timezones. In Postgresql when calculating the interval between events

for recurring events, we need to ignore the timezone to get the

correct result when the event crosses the Daylight Saving Time boundar.

    • -0
    • +248
    ./postgresql/upgrade/upgrade-0.6d2-0.6d3.sql
Merged changes to HEAD ...

    • -0
    • +748
    ./oracle/upgrade/upgrade-0.6d1-0.6d2.sql
    • -0
    • +357
    ./postgresql/upgrade/upgrade-0.6d1-0.6d2.sql
  1. … 1553 more files in changeset.
Fixed typo in daveb's change

Make sure "this event" is updated when editing a reucrrence and applying

to this event and all future events

    • -2
    • +2
    ./oracle/upgrade/upgrade-0.6d1-0.6d2.sql
file upgrade-0.6d1-0.6d2.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.6d1-0.6d2.sql
All editing only future events of a recurrence

    • -0
    • +748
    ./oracle/upgrade/upgrade-0.6d1-0.6d2.sql
Fix handling of recurring events over DST. Add upgrade script. NOTE:

only needed on postgresql since Oracle doesn't store timezones.

    • -0
    • +292
    ./postgresql/upgrade/upgrade-0.6d1-0.6d2.sql
  1. … 1 more file in changeset.
file upgrade-0.6d1-0.6d2.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6d1-0.6d2.sql
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

    • -378
    • +377
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
    • -207
    • +208
    ./postgresql/timespan-create.sql
  1. … 2474 more files in changeset.
fixing typos -- missing semicolons

fixing typos -- missing semicolons in acs_event__get_html_p and acs_event__get_status_summary

Initual attempt at correct daylight savings time handling. When calculating

intervals for copy, recurring events treat dates in calculations as timestamp

without timezone.

    • -207
    • +208
    ./postgresql/timespan-create.sql
typo fix, add a missing comma

    • -1
    • +1
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
fix pacakge -> package typo

    • -1
    • +1
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
  1. … 9 more files in changeset.
fix the bkwd compat acs_event__new function resolves bug 2383

propigate package_id to acs_objects, make __new a 14 param function and add backwards compatible version, bump package version, upgrades for oracle and pg, oracle untested

    • -0
    • +737
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
    • -0
    • +161
    ./postgresql/upgrade/upgrade-0.5d2-0.5d3.sql
  1. … 1 more file in changeset.
make functions create or replace. fix inputs to a get_status_summary and get_html_p, bump version, upgrade

    • -26
    • +26
    ./postgresql/acs-events-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
  1. … 1 more file in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

    • -0
    • +631
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 92 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

    • -631
    • +0
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 91 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

    • -0
    • +631
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
    • -0
    • +204
    ./postgresql/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 91 more files in changeset.
fixing bug 957: adding recurring events broken in PG. Adding ::INT casts to arguments of add_months() and to_interval() calls

Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +1732
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 23 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 270 more files in changeset.
added upgrade script for index creation on start_date (see bug #634)

    • -0
    • +1
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

  1. … 6 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -14
    • +14
    ./postgresql/acs-events-create.sql
    • -25
    • +25
    ./postgresql/timespan-create.sql
    • -44
    • +44
    ./postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./postgresql/test/timespan-test.sql
  1. … 33 more files in changeset.