• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- modernize SQL (dollar quoting, named arguments, fix and complete function_args)

    • -14
    • +14
    ./postgresql/bulk-mail-create.sql
    • -33
    • +53
    ./postgresql/bulk-mail-package-create.sql
    • -33
    • +53
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -24
    • +38
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
Provide upgrade script for bug 3103

    • -0
    • +69
    ./postgresql/upgrade/upgrade-0.5.2d1-0.5.2d2.sql
  1. … 1 more file in changeset.
bug #3103 change to_date to to_timestamp in bulk_mail__new function

    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2476 more files in changeset.
1. Oracle bulk-mail-create.sql did not agree with the 5.1d2 upgrade script (made it so)

2. PG didn't have the contraint, added it to bulk-mail-create.sql and made and

tested an upgrade script.

Thanks to Richard Hamilton for uncovering this discrepancy.

file upgrade-0.5.1d1-0.5.1d2.sql was initially added on branch oacs-5-2.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

    • -1
    • +3
    ./postgresql/bulk-mail-package-create.sql
  1. … 2275 more files in changeset.
Added forgotten return to bulk_mail__delete plsql postgres function

    • -1
    • +3
    ./postgresql/bulk-mail-package-create.sql
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 687 more files in changeset.
file upgrade-0.5.1d1-0.5.1d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5.1d1-0.5.1d2.sql
named upgrade script incorrectly on the first try

    • -4
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
  1. … 1 more file in changeset.
file upgrade-0.5-0.5d1.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
forgot to commit upgrade script. this is a constraint change, so Oracle only

    • -0
    • +4
    ./oracle/upgrade/upgrade-0.5-0.5d1.sql
  1. … 1 more file in changeset.
merge of all changes on oacs-5-0 branch between tag openacs-5-0-0-final and jcd-merge-pre503 (except those in lars-blogger).

    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  1. … 290 more files in changeset.
Replaced 3 defunct upgrade scripts with one new upgrade script that works

    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +181
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
    • -72
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -38
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
file upgrade-0.1a-0.4.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.4.sql
Fixed bug #989: Page error when requesting membership - bulk_mail_messages.query column was changed from varchar to clob

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

    • -0
    • +110
    ./oracle/upgrade/upgrade-0.4-0.5.sql
  1. … 23 more files in changeset.
making upgrade scripts of bulk-mail work with PG 7.2

    • -9
    • +68
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -9
    • +69
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
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. … 274 more files in changeset.
Added define_function_args: bug #55

    • -0
    • +3
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

    • -0
    • +42
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -9
    • +9
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  1. … 806 more files in changeset.
changes to support outgoing HTML e-mail from bulk mail, incoming HTML email to forums, and prevent MIT's vacation messages from making it into forums

    • -0
    • +42
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -9
    • +9
    ./postgresql/bulk-mail-package-create.sql
    • -3
    • +3
    ./postgresql/bulk-mail-views-create.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
  1. … 9 more files in changeset.
file upgrade-0.3-0.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.3-0.4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
send_date needs to be timestamptz

    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
  1. … 1 more file in changeset.
file upgrade-0.2-0.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.2-0.3.sql
file upgrade-0.1a-0.2.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/upgrade/upgrade-0.1a-0.2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
modified query column to be of type clob for oracle and type text for

postgresql.

    • -0
    • +13
    ./postgresql/upgrade/upgrade-0.1a-0.2.sql
  1. … 1 more file in changeset.
merge of 4.6.3b1 to HEAD

    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-package-drop.sql
  1. … 75 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 ...

    • -2
    • +2
    ./postgresql/bulk-mail-package-create.sql
    • -2
    • +2
    ./postgresql/bulk-mail-package-drop.sql
  1. … 52 more files in changeset.