• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Modified cc_users moving the magic object lookup to its own query. The view was really slow when joined against the acs_magic_objects table.

file upgrade-5.1.2d2-5.1.2d3.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.2d2-5.1.2d3.sql
Changed cc_users and registered_users views to use the acs__magic_object_id

function that was written quite some time ago but never used in those views.

And those views are really slow when joined against the acs_magic_objects

table ...

    • -0
    • +28
    ./postgresql/upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  1. … 1 more file in changeset.
preserve last_modified when explicitly updated, replaces acs_objects_last_mod_update_tr, bump version, upgrade scripts

    • -0
    • +15
    ./oracle/upgrade/upgrade-5.2.0d6-5.2.0d7.sql
    • -0
    • +17
    ./postgresql/upgrade/upgrade-5.2.0d6-5.2.0d7.sql
  1. … 1 more file in changeset.
fix some bugs which break things in pg7.5; mostly syntax errors in existing procs.

    • -0
    • +94
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  1. … 1 more file in changeset.
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

    • -0
    • +192
    ./oracle/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
    • -0
    • +40
    ./postgresql/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  1. … 113 more files in changeset.
flip order of delete for group delete

flip order of delete of rels and rel segments, bump version to 5.1.2d2, upgrade scripts for oracle and pg, bug 775 patch 267 Randy O'Meara

    • -0
    • +192
    ./oracle/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
    • -0
    • +40
    ./postgresql/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  1. … 1 more file in changeset.
file upgrade-5.1.2d1-5.1.2d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
Wouldn't let me tag after adding to HEAD so am committing directly...

    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
Committing re-added upgrade file

    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
Oops did this wrong ... want to do exactly what Andrew did for consistency

    • -61
    • +0
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
Upgrade to apply previous register parameter bug fix

    • -0
    • +61
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
file upgrade-5.1.1d1-5.1.1d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
name constraints

name constraints and make lob_data.lob_id on delete cascade

    • -3
    • +7
    ./postgresql/authentication-create.sql
Update to apm package body in v1.26.2.1 of apm-create.sql,to include a bugfix/simplication to the cursor in apm.register_parameter.

    • -0
    • +384
    ./oracle/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
Ported Andrew's Oracle patch to register parameter.

Ported Andrew's Oracle register parameter patch.

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 686 more files in changeset.
Simplifying the cursor in apm.register_parameter to fix a bug, and make it simpler. Don's doing the PG version.

Looks like someone snuck in a little 'x' too much.

make the apm_package_version_attr version_id on delete cascade, otherwise deleting packages fails (forgot oracle file)

make the apm_package_version_attr version_id on delete cascade, otherwise deleting packages fails

fix the static cvs-id tags

    • -1
    • +1
    ./postgresql/acs-permissions-create.sql
    • -1
    • +1
    ./postgresql/acs-relationships-create.sql
    • -1
    • +1
    ./postgresql/acs-relationships-drop.sql
  1. … 18 more files in changeset.
TYPO: should read parameter, not paramer

Merging fix from oacs-5-1 branch onto HEAD

Applied Dave's bugfix for \#1419 here to fix the same bug

do not create the cc_users_of_package_id view since we dont create application_users view anymore so its not used

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

    • -2
    • +13
    ./postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  1. … 832 more files in changeset.