• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.
Seperate delete of perissions by grantee_id into its own statement.

Fixes bug#1419

integrity violation fix for acs_object__delete function. Making it delete matching acs_permission.grantee_id records in addition to the object_id ones. Bumping version of kernel to 5.0.0b5

  1. … 4 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
Adds max_child_sortkey to acs_objects, uses select for update to incr

tree_sortkey (fixes concurrency problems and substantially improves

performance), drop group_elem_idx_container_idx (not useful) and

acs_objects_context_object_idx (which is superflous since there is an

identical unique constraint). changes acs_objects_get_tree_sortkey to

be isstrict/iscachable fixes a bug in acs_objects_context_id_up_tr on

both oracle an postgres.

See http://openacs.org/forums/message-view?message_id=142769 for discussion.

  1. … 7 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files in changeset.
Added Barry Brook's speed-up to the object context update trigger (untested as

yet, will get Janine to test at Sloan)

add user id and IP address to update_last_modified()

  1. … 10 more files in changeset.
Merged with 4.6 branch

  1. … 30 more files in changeset.
Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

  1. … 17 more files in changeset.
change the delete from acs_permissions to be a dynamic sql delete since the table is not defined at the time the package body is created. Its a hack but further cleanup will have to wait for 4.7

  1. … 1 more file in changeset.
Fixed various problems with the new permissions and minor main site changes

  1. … 5 more files in changeset.

First cut at Oracle perm rewrite and some whacking around on the PG version

  1. … 10 more files in changeset.
delete direct permissions in acs_object__delete (oracle and postgres) upgrade provided, bug 234 patch 74 Tilmann Singer

  1. … 3 more files in changeset.
using connect by in oracle version of update_last_modified (plpgsql version is still using recursive version)

created acs_object.update_last_modified procedure that takes in an object_id

and an optional timestamp and sets the last_modified time of the object and

all of it's parents (not including object 0) to the last_modified time passed

in or sysdate if none was passed in.

  1. … 1 more file in changeset.

Merged with OpenACS 4.5 beta1 branch.

  1. … 88 more files in changeset.

Yep, previous Oracle fix had a problem! "case" isn't allowed in PL/SQL???

1. Community core change was due to an earlier patch that allows a person

to register as a user.

2. Deleting an acs-object would fail if the object specific table didn't exist.

acs-objects and the content repository shouldn't require type specific tables

be named when you extend a type, this is a temporary hack which acknowledges

that folks have been cheating by name non-existent tables. Since I plan to

remove the restriction anyway, this is not a big deal.

The Oracle version still needs testing ...

  1. … 2 more files in changeset.
fixed closing of cursors after an exception

  1. … 4 more files in changeset.

1. Polished up the query files for the root www directory

2. Turned a bunch of bitmap indexes into b-tree indexes

3. the developer support .info file had been messed over by an early

version of my APM port to PG.

  1. … 8 more files in changeset.

bootstrapper can now load either the Oracle or PostgreSQL acs-kernel

datamodel. It checks on-the-fly for which db is configured in the OpenNSD

database pools allocated to OpenACS. Only acs-kernel is correctly self-

configured at this point.

    • -0
    • +1024
    ./acs-objects-create.sql
  1. … 113 more files in changeset.