• last updated 19 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typo

    • -2
    • +2
    ./upgrade/upgrade-5.10.0d10-5.10.0d11.sql
schema queries: allow mixed case for column and table names (similar to function_args

bump versiom number to 5.10.0d11

    • -0
    • +157
    ./upgrade/upgrade-5.10.0d10-5.10.0d11.sql
  1. … 1 more file in changeset.
proivde upgrades script for PG 11 and bump version number to 5.9.2d2

    • -0
    • +45
    ./upgrade/upgrade-5.9.2d1-5.9.2d2.sql
  1. … 1 more file in changeset.
file upgrade-5.9.2d1-5.9.2d2.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-5.9.2d1-5.9.2d2.sql
backport from HEAD for PG 11

[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11

improve comments and spelling

  1. … 1 more file in changeset.
fix issue #3360; probably a problem that shows up with pg10.

make checking of pg_version number more robust (backporting changes from head).

See also issue #3359

Fix typos

  1. … 1 more file in changeset.
Removed obsolete @arch-tag

    • -2
    • +1
    ./upgrade/upgrade-5.2.0d11-5.2.0d12.sql
  1. … 30 more files in changeset.
Fix typo

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d7-5.10.0d8.sql
Change database type for boolean from "bool" to "boolean" in acs_datatypes

    • -0
    • +7
    ./upgrade/upgrade-5.10.0d7-5.10.0d8.sql
  1. … 1 more file in changeset.
Remove reference to legacy datamodel

...chances are few this code will be ever executed anyhow, as is the dropping script for the very kernel

  1. … 1 more file in changeset.
Remove obsolete table apm_package_db_types: this was superseded by threaded cache ::acs::known_database_types

    • -0
    • +5
    ./upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 4 more files in changeset.
imporve spelling

  1. … 5 more files in changeset.
fix typo

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
Replace obsolete function bitfromint4() by cast

    • -0
    • +38
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  1. … 1 more file in changeset.
Replace obsolete funktion bittoint4() by cast

    • -0
    • +78
    ./upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 1 more file in changeset.
fix singular/plural typos

  1. … 6 more files in changeset.
Fix typos

  1. … 31 more files in changeset.
improve spelliing

  1. … 2 more files in changeset.
Fix typos

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 6 more files in changeset.
Fix typos

  1. … 61 more files in changeset.
Fix typos

  1. … 28 more files in changeset.
Upgrade fix

Execute cleanup only if explicitly uncommented, as might have performance implications.

Also, correct unaligned constraint names in old instances upgraded incrementally over the years.

    • -6
    • +7
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 1 more file in changeset.
Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

    • -0
    • +80
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 15 more files in changeset.
Fix typos

  1. … 7 more files in changeset.
Backfix upgrade to be PostgreSQL 9.0 compliant

    • -4
    • +2
    ./upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Backport fix to https://openacs.org/bugtracker/openacs/bug?format=table&bug_number=3331: fix original problematic update

    • -4
    • +2
    ./upgrade/upgrade-5.9.1d19-5.9.1d20.sql