• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- Convert frequenty used functions from plpgsql

to strict and stable SQL functions, which allow

the PostgreSQL more optimizations

* acs_group__member_p/3

* site_node__url/1

- bump version number to 5.10.0d27

    • -0
    • +59
    ./upgrade/upgrade-5.10.0d26-5.10.0d27.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d26-5.10.0d27.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d26-5.10.0d27.sql
Attribute discrepancy fix for object_types in OpenACS.

Some attributes are not created for new instances since 2006, but an upgrade

script deleting the already existing ones was never done.

Original datatype change:

https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933

https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb

    • -0
    • +60
    ./upgrade/upgrade-5.10.0d25-5.10.0d26.sql
  1. … 2 more files in changeset.
file upgrade-5.10.0d25-5.10.0d26.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d25-5.10.0d26.sql
  1. … 1 more file in changeset.
Add oracle upgrade logic for previous attribute datatype discrepancy package upgrades, and fix typo in postgres upgrade script

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d24-5.10.0d25.sql
  1. … 2 more files in changeset.
Fix attribute datatype discrepancy, introduced in 2006 but never fixed for already existing instances.

Original datatype change:

https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933

https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb

    • -0
    • +18
    ./upgrade/upgrade-5.10.0d24-5.10.0d25.sql
  1. … 3 more files in changeset.
file upgrade-5.10.0d24-5.10.0d25.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d24-5.10.0d25.sql
Index acs_object's creation and modification date

    • -0
    • +4
    ./upgrade/upgrade-5.10.0d23-5.10.0d24.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d23-5.10.0d24.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d23-5.10.0d24.sql
make return arguments explicit

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d20-5.10.0d21.sql
Whitespace cleanup

Redefine acs_group__member_p so that direct membership is checked in a way that is uniform with that of cascading membership: without any permission check (fixes acs_subsite_check_composite_group automated test)

    • -0
    • +35
    ./upgrade/upgrade-5.10.0d22-5.10.0d23.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d22-5.10.0d23.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d22-5.10.0d23.sql
Define an acs_object schema and use it to redefine acs_object__name using dot notation

Goal is to further reduce code divergency between Oracle and Postgres

    • -0
    • +76
    ./upgrade/upgrade-5.10.0d21-5.10.0d22.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d21-5.10.0d22.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d21-5.10.0d22.sql
improve spelling

  1. … 6 more files in changeset.
improve spelling

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d10-5.10.0d11.sql
    • -2
    • +2
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  1. … 30 more files in changeset.
Add upgrade script to cleanup 'acs_object_context_index' and friends

    • -0
    • +54
    ./upgrade/upgrade-5.10.0d20-5.10.0d21.sql
file upgrade-5.10.0d20-5.10.0d21.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d20-5.10.0d21.sql
implementing feature request #3408: support for passing in null values to acs_object__set_attribute

    • -0
    • +30
    ./upgrade/upgrade-5.10.0d19-5.10.0d20.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d19-5.10.0d20.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d19-5.10.0d20.sql
Move away portraits created as children of the -100 object that might be still around after acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql

    • -0
    • +20
    ./upgrade/upgrade-5.10.0d17-5.10.0d18.sql
  1. … 2 more files in changeset.
file upgrade-5.10.0d17-5.10.0d18.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d17-5.10.0d18.sql
  1. … 1 more file in changeset.
Data model upgrade for those instances that might have missed the renaming of the person object type

    • -0
    • +10
    ./upgrade/upgrade-5.10.0d16-5.10.0d17.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d16-5.10.0d17.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d16-5.10.0d17.sql
file upgrade-5.10.0d15-5.10.0d16.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d15-5.10.0d16.sql
Modernize SQL existence test: make it more readable and faster

    • -0
    • +17
    ./upgrade/upgrade-5.10.0d15-5.10.0d16.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d14-5.10.0d15.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.0d14-5.10.0d15.sql
Modernize SQL existence test: make these more readable and faster

    • -0
    • +92
    ./upgrade/upgrade-5.10.0d14-5.10.0d15.sql
  1. … 1 more file in changeset.
backport from oacs-5-10 to allow installation of old version on pg11