• last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typos

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

  1. … 16 more files in changeset.
Fix typos

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

  1. … 7834 more files in changeset.
- second part of Part 4 of OpenACS 5.9 agenda: get rid of tree_sortkey in acs-objects : getting rid of functions accessing acs_objects.tree_sortkey when creating new instances

- use variable names "ot1" and "ot2" instead of "o1" and "o2" when referring to object_types (and not objects)

  1. … 1 more file in changeset.
- scalability reform part 1

* remove manual delete operations from acs_object__delete()

where update is as achieved automatcially via cascade operations

* improve documentation of source code

- bump version number to 5.9.0d2

  1. … 2 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2547 more files in changeset.
Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

  1. … 54 more files in changeset.
Merged oacs-5-6 to HEAD. HEAD now installs and passes all core tests. There

may still be some lingering problems due to my screwing up the oacs-5-6

branch earlier, I'll be looking into this later.

  1. … 214 more files in changeset.
Changes for supporting postgresql 9.0:

- Avoiding usage of SQL reserved keywords on plpsql functions (plpsql lexer and parser were reworked).

- Fixing all those places on which FROM clause was automatically added by PG ( PG Config add_missing_from parameter was removed for this release of PG ).

Many thanks to Tracy Adams and Jeff Lu for providing first version of the patches.

  1. … 16 more files in changeset.
1. Changed trigger functions from "opaque" to "trigger" to get rid of the

warnings during initial install (only for acs-kernel, there are a lot

elsewhere!)

2. Added "embeds" for postgresql and partially for oracle.

3. Added global parameters for postgresql and partially for oracle.

(oracle will be forthcoming shortly)

  1. … 29 more files in changeset.
Added some missing attributes (more to go, though, damn core datamodel)

  1. … 3 more files in changeset.
Someone didn't realize that "foo;null" in define_function_args calls sets the

default value to 'null' not NULL...this has been there a long time ... maybe

even my fault, but I don't remember, it's ancient!

  1. … 1 more file in changeset.
- Add two missing indices to improve performance of permission system

and the object context hierarchy significantly (these two indices

improved the performance of e.g. /projects/openacs/download/ and

/projects/openacs/download/one-revision?revision_id=2089636 by more

than a factor of 10; these indices are now among the most used on

openacs.org)

- Bump version number

  1. … 5 more files in changeset.
Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

  1. … 9 more files in changeset.
adding missing function args, fixing incorrect function args, including upgrade script

  1. … 3 more files in changeset.
Correction of name constraint

  1. … 13 more files in changeset.
Realized that I only need to define function args for the most verbose

form of acs_object__new, since package_instantiate_object handles

default values very nicely.

  1. … 1 more file in changeset.
A variety of group oriented things, and finally added the definitions of

acs-objects package procs in PG so that we can use package_instantiate_object

and package_db_exec with them.

  1. … 10 more files in changeset.
preserve last_modified when explicitly updated, replaces acs_objects_last_mod_update_tr, bump version, upgrade scripts

  1. … 4 more files in changeset.
fix the static cvs-id tags

  1. … 32 more files in changeset.
minor typo prevented setting title even if provided in acs_object__new

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.
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.
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.
Applied patch #280 for bug #820

  1. … 1 more file 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.
Corrected PG version of Barry Brooks speed up to the object update trigger,

added the new Oracle trigger to the proper upgrade script.

  1. … 2 more files in changeset.