• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixing bug 957: adding recurring events broken in PG. Adding ::INT casts to arguments of add_months() and to_interval() calls

    • -3
    • +3
    ./sql/postgresql/acs-events-create.sql
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +1732
    ./sql/oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 23 more files in changeset.
Updated version numbers to upgrade to changes made for Oracle 9i support

  1. … 37 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)

    • -12
    • +12
    ./sql/oracle/timespan-create.sql
    • -30
    • +30
    ./sql/oracle/test/timespan-test.sql
  1. … 270 more files in changeset.
info file fix: making version name in version url be up-to-date (have the version name in it). Upgrades fail on unique constraint of version url otherwise.

  1. … 1 more file in changeset.
Bumped up EventFutureLimit to 5 (see #523)

added upgrade script for index creation on start_date (see bug #634)

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +1
    ./sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql
Remove 'ACS' from the package nme

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
    ./sql/postgresql/acs-events-create.sql
    • -9
    • +9
    ./sql/postgresql/oracle-compat-create.sql
    • -4
    • +4
    ./sql/postgresql/oracle-compat-drop.sql
    • -4
    • +4
    ./sql/postgresql/recurrence-create.sql
    • -25
    • +25
    ./sql/postgresql/timespan-create.sql
    • -44
    • +44
    ./sql/postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./sql/postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./sql/postgresql/test/timespan-test.sql
    • -5
    • +5
    ./sql/postgresql/test/utest-create.sql
  1. … 32 more files in changeset.
removing the file listings from the info files since those are no longer used by OpenACS

  1. … 28 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

    • -44
    • +44
    ./sql/postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./sql/postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./sql/postgresql/test/timespan-test.sql
    • -5
    • +5
    ./sql/postgresql/test/utest-create.sql
  1. … 50 more files in changeset.
Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

    • -14
    • +14
    ./sql/postgresql/acs-events-create.sql
    • -9
    • +9
    ./sql/postgresql/oracle-compat-create.sql
    • -4
    • +4
    ./sql/postgresql/oracle-compat-drop.sql
    • -4
    • +4
    ./sql/postgresql/recurrence-create.sql
    • -25
    • +25
    ./sql/postgresql/timespan-create.sql
  1. … 13 more files in changeset.
Changed link to SDM to a link to bug-tracker.

merge bartt PG 7.3 fixes from HEAD

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
    • -2
    • +2
    ./sql/postgresql/test/acs-events-test.sql
  1. … 51 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
    • -2
    • +2
    ./sql/postgresql/test/acs-events-test.sql
  1. … 51 more files in changeset.
merge from oacs-4-6

    • -15
    • +9
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 108 more files in changeset.
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

    • -15
    • +9
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 28 more files in changeset.
changing to provide acs-events (like package_key) rather than acs-event, calendar won't install otherwise

- Converted inneficient query to INNER JOINs.

- Added Oracle upgrade script.

    • -0
    • +740
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -11
    • +18
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
acs-events provided acs-event. now provides matches package key

  1. … 1 more file in changeset.
Added new files to .info files

  1. … 38 more files in changeset.
fix some broken links

  1. … 23 more files in changeset.
manually updating the .info file since the UI is not working for me. bumped revto 0.2d

adding upgrade file for acs_event__recurrence_timespan_edit fuction fix

    • -0
    • +47
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
fix acs_event__recurrence_timespan_edit thanks to deds@infiniteinfo.com

    • -12
    • +24
    ./sql/postgresql/acs-events-create.sql
fixed calendar for PG

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
  1. … 10 more files in changeset.
added support for editing time intervals

    • -1
    • +32
    ./sql/postgresql/acs-events-create.sql

Added some stuff to acs-events, like an html_p arg to "new" to set this

existing but unused table column.

    • -32
    • +79
    ./sql/postgresql/acs-events-create.sql
    • -12
    • +37
    ./sql/postgresql/activity-create.sql
    • -15
    • +18
    ./sql/postgresql/test/acs-events-test.sql
applied patches 130,131,132,133,134,135,137

    • -2
    • +2
    ./sql/postgresql/acs-events-create.sql
  1. … 7 more files in changeset.