• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
make packages in principle installable under PG 13+

  1. … 19 more files in changeset.
file upgrade-5.10.0d7-5.10.0d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
Don't rely on the delete trigger being named consistently on different installations

    • -1
    • +15
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
Add again double quotes in the add constraint as well

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
Add double quotes in case constraints were defined using e.g. $ in the old days

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
Put on delete cascade defined in previous upgrades in creation sql as well

Faq vs Search trigger reform: turns out after delete trigger on faq_q_and_as is quite pointless and makes it more complicated for faq package instances to properly uninstantiated. More details in the comments.

    • -0
    • +24
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 3 more files in changeset.
Introduce ON DELETE CASCADE on faq main datamodel tables, so generic acs_object db api can be used to e.g. delete a faq (fixes downstream errors when deleting FAQ package)

    • -0
    • +64
    ./oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
    • -0
    • +62
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  1. … 1 more file in changeset.
Removed obsolete @arch-tag

  1. … 25 more files in changeset.
Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ignores Oracle, as its behavior with respect to case is not clear to me.

    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  1. … 1 more file in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7832 more files in changeset.
file upgrade-5.9.0-5.9.1d1.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -18
    • +19
    ./postgresql/faq-package-create.sql
    • -9
    • +17
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 2544 more files in changeset.
file upgrade-5.8.1d2-5.8.1d3.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d2-5.8.1d3.sql
missing ';'.

Fixing null package_id's for faq and faq_q_and_as objects. Patch orignally provided by Gustaf Neumann.

    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  1. … 1 more file in changeset.
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -45
    • +92
    ./postgresql/faq-package-create.sql
  1. … 21 more files in changeset.
Merged oacs-5-3 branch to HEAD

    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  1. … 184 more files in changeset.
file faq-sc-create.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./postgresql/faq-sc-create.sql
file upgrade-5.2.0d4-5.2.0d5.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
Renamed a mis-named variable.

split package from datamodel create, add fts contract, update for tip 42,43 fix name_method on pg

    • -0
    • +217
    ./oracle/faq-package-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -0
    • +171
    ./postgresql/faq-package-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 3 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. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -0
    • +45
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 33 more files in changeset.
file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
merge from oacs-4-6

    • -0
    • +212
    ./oracle/upgrade/upgrade-4.0-4.6.sql
  1. … 101 more files in changeset.
file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/upgrade/upgrade-4.0-4.6.sql
added news and faq dotlrn applets

  1. … 15 more files in changeset.
pg port of faq

    • -0
    • +266
    ./postgresql/faq-create.sql
    • -0
    • +129
    ./postgresql/faq-drop.sql