• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c for membership and composition triggers

Warning: Trigger created with compilation errors.

Errors for TRIGGER MEMBERSHIP_RELS_IN_TR:

LINE/COL ERROR

-------- -----------------------------------------------------------------

14/3 PL/SQL: SQL Statement ignored

16/3 PL/SQL: ORA-00947: not enough values

32/3 PL/SQL: Statement ignored

32/6 PLS-00201: identifier 'V_COMPOSABLE_P' must be declared

Trigger created.

No errors.

Warning: Trigger created with compilation errors.

Errors for TRIGGER COMPOSITION_RELS_IN_TR:

LINE/COL ERROR

-------- -----------------------------------------------------------------

72/21 PL/SQL: SQL Statement ignored

72/48 PL/SQL: ORA-00918: column ambiguously defined

83/7 PL/SQL: Statement ignored

83/47 PLS-00364: loop index variable 'MEMBERS' use is invalid

86/5 PL/SQL: SQL Statement ignored

91/6 PL/SQL: ORA-00918: column ambiguously defined

Trigger created.

No errors.

  1. … 1 more file in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
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.
- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

- bump version number to 5.9.1d10

  1. … 6 more files in changeset.
Fixed daveb's connect by and nextval, for initial install and upgrade (change

to acs_group.new)

  1. … 1 more file in changeset.
Fix acs_group__new to create group_rels for all group supertypes

  1. … 4 more files in changeset.
Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Fixed someone's typo in the new "merge" pl/sql procs

Adding the member_state 'merged'. Added plsql functions and upgrade scripts for oracle and pg.

  1. … 6 more files 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

  1. … 116 more files in changeset.
flip order of delete for group delete

Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.
fixing a syntax error

TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 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.
1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

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

  1. … 30 more files in changeset.
Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

  1. … 4 more files in changeset.
Accidently dropped the latest PG rather than Oracle versions of these files

here.

  1. … 3 more files in changeset.
Migrated the 4.6.1 permissions stuff to HEAD

  1. … 7 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.
Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

  1. … 4 more files 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.

Added C. R. Oldham's patch to fix membership testing (unimplemented in ACS

4.2). Ported it to PG on the way ...

  1. … 9 more files in changeset.

Fixed a few spelling mistakes

Ported a bunch more of acs-subsite

Fixed a few small, acs-subsite related bugs

  1. … 41 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
    • +749
    ./groups-body-create.sql
  1. … 113 more files in changeset.