• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
  1. … 1 more file in changeset.
file upgrade-5.9.1-5.9.2d1.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1-5.9.2d1.sql
Fix typo

Use PostgreSQL 9.0 compatible idioms in 'sql' stored procedure

    • -0
    • +20
    ./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

    • -2
    • +2
    ./oracle/site-node-object-map-create.sql
    • -2
    • +2
    ./oracle/test/rel-constraints-test.sql
    • -2
    • +4
    ./oracle/test/rel-segments-test-types-create.sql
    • -0
    • +344
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
  1. … 7820 more files in changeset.
Fix spelling errors

    • -2
    • +2
    ./oracle/test/rel-constraints-test.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-4.5-4.5.1.sql
    • -5
    • +5
    ./oracle/upgrade/upgrade-4.6-4.6.1d1.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -11
    • +11
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -6
    • +6
    ./oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql
  1. … 34 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).

    • -4
    • +17
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
Added missing data model upgrade from version 5.2, affecting long lived installations.

    • -0
    • +14
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
  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
    ./postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql
applied changes provided by Brian for oracle. For details, see issue #3302

    • -143
    • +61
    ./oracle/utilities-create.sql
    • -123
    • +60
    ./oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -142
    • +59
    ./oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Fix issue #3300 and #3301: index name breaks Oracle name length limit of 30 chars

    • -2
    • +2
    ./oracle/site-node-object-map-create.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

    • -0
    • +245
    ./oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
    • -0
    • +21
    ./postgresql/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d19-5.9.1d20.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
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

    • -0
    • +225
    ./oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -9
    • +155
    ./postgresql/utilities-create.sql
    • -0
    • +155
    ./postgresql/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
- 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)

    • -2
    • +2
    ./postgresql/acs-permissions-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.9.1d10-5.9.1d11.sql
- 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.

    • -18
    • +8
    ./postgresql/upgrade/upgrade-5.9.1d3-5.9.1d4.sql
- don't change names of arguments unless necessary, since such cases require a DROP FUNCTION

    • -11
    • +15
    ./postgresql/upgrade/upgrade-5.9.0d5-5.9.0d6.sql
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

    • -2
    • +4
    ./oracle/test/rel-segments-test-types-create.sql
    • -0
    • +344
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -19
    • +55
    ./postgresql/acs-relationships-create.sql
    • -25
    • +36
    ./postgresql/groups-body-create.sql
    • -2
    • +4
    ./postgresql/test/rel-segments-test-types-create.sql
    • -0
    • +376
    ./postgresql/upgrade/upgrade-5.9.1d15-5.9.1d16.sql
    • -4
    • +6
    ./test/rel-segments-test-types-create.sql
  1. … 21 more files in changeset.
file upgrade--5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
file upgrade-5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d15-5.9.1d16.sql
- use dollar quoting for SQL comments

- add verbosity setting

- make it easy to log SQL statements as these are executed

- 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

    • -35
    • +44
    ./postgresql/site-nodes-create.sql
    • -0
    • +102
    ./postgresql/upgrade/upgrade-5.9.1d14-5.9.1d15.sql
  1. … 2 more files in changeset.
file upgrade-5.9.1d14-5.9.1d15.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/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