• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.

  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-5.10.0d3-5.10.0d4.sql
  1. … 16 more files in changeset.
Fix typos

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

Backport fix to https://openacs.org/bugtracker/openacs/bug?format=table&bug_number=3331: fix original problematic update

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

    • -0
    • +0
    ./upgrade-5.9.1-5.9.2d1.sql
Use PostgreSQL 9.0 compatible idioms in 'sql' stored procedure

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

  1. … 7820 more files in changeset.
Fix spelling errors

  1. … 45 more files in changeset.
Fix upgrade logics, because old instances named constraint differently. Also, skip execution when not needed, as can be demanding (acts on acs_objects).

Added missing data model upgrade from version 5.2, affecting long lived installations.

  1. … 1 more file in changeset.
file upgrade-5.9.1b3-5.9.1b4.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1b3-5.9.1b4.sql
Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

  1. … 4 more files in changeset.
file upgrade-5.9.1d19-5.9.1d20.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1d19-5.9.1d20.sql
  1. … 1 more file in changeset.
Added new database functions to check for various properties and constraints in database metadata:

- foreign key constraint

- unique constraint

- not null constraint

- get column default value

  1. … 4 more files in changeset.
file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1d18-5.9.1d19.sql
  1. … 1 more file in changeset.
- Improved compatiblity with PostgreSQL before 9.2:

don't use SQL-language function names to reference parameters to

obtain compatibility for earlier PostgreSQL versions

(see https://www.postgresql.org/docs/9.2/static/release-9-2.html

item E.19.3.9.3)

  1. … 1 more file in changeset.
- fix upgrade script for PostgreSQL before 9.2: the old version checked

already the version number, but actually the SQL compilation failed

due to the unknown "IF EXISTS" for sequences.

- don't change names of arguments unless necessary, since such cases require a DROP FUNCTION

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

  1. … 34 more files in changeset.
file upgrade-5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1d15-5.9.1d16.sql
- added kernel parameter MaxUrlLength (default 2000) to remove

hard-coded length in request-processor-procs.

- lifted data model restriction of 100 characters for url-segments

(changing types of "site_nodes.name" from "varchar(100)" to "text")

(PostgreSQL only)

- site_node__node_id

* use built-in string functions instead of characterwise loop

* use default for last argument

* Improve source-code documentation

- bumped version number of kernel to 5.9.1d15

  1. … 3 more files in changeset.
file upgrade-5.9.1d14-5.9.1d15.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.9.1d14-5.9.1d15.sql
- improve source code documentation

- polishing update script

- make same change as well for older pg versions

- make upgrade script more robust to allow multiple runs

- fix upgrade script

- remove dependency on acs_object_party_privilege_map

  1. … 2 more files in changeset.