• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

  1. … 8 more files in changeset.
make packages in principle installable under PG 13+

  1. … 19 more files in changeset.
make FAQ package installable under PG 13+

Redefine faq questions and answers as text, the same as downstream, then redefine all database function api so that argument types are taken from table definition

    • -27
    • +29
    ./postgresql/faq-package-create.sql
    • -0
    • +156
    ./postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
  1. … 1 more file 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
Bring files on oacs-5-10 in sync with HEAD

  1. … 160 more files in changeset.
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.
Add another constraint name variant as it existed in our production system

Added missing comma

- add missing semicolons

- provide support for old installations, with other constaint names

Alter caveman style booleans (type character(1)) to real SQL boolean types.

  1. … 4 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.
- add upgrade files

  1. … 1 more file 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
- add missing function args

- bump version number

  1. … 1 more file in changeset.
- use dollar quoting

- modernize SQL

    • -9
    • +17
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  1. … 2 more files in changeset.
- fix partial SQL edit

    • -18
    • +17
    ./postgresql/faq-package-create.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.