• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Add "FOR UPDATE" to select operation of *_f() function inserting tuples.

the required "content_type__refresh_trigger" calls will follow later.

  1. … 2 more files in changeset.
fix broken API function acs_object_type::get_table_name (broken since 13 years) and use API instead of direct SQL queries

  1. … 7 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.
add text/markdown to known content types (like text/enhanced), bump version number to 5.10.0d4

  1. … 3 more files in changeset.
Bring legacy versions of image__new() in sync with the actual definitions

  1. … 2 more files in changeset.
Fix typo in variable name "new_nls_language" (must be "new__nls_language")

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

  1. … 7834 more files in changeset.
Bumping up core packages version to 5.10.0d1

  1. … 24 more files in changeset.
- Part 4 of OpenACS 5.9 agenda: get rid of tree_sortkey in acs-objects ; to be on the safe side, backup your database before upgrading, since the acs-objects.treesortkey is being removed (custom packages might erroneously depend on it)

  1. … 4 more files in changeset.
- update release date

- added missing semicolon

- make script robust against multiple loads

  1. … 1 more file in changeset.
Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

  1. … 4 more files in changeset.
- Scalability reform part 2:

* remove cases in the content repository where referencial

integrity was handled manually. Ancient versions of

PostgresSQL seemed to have a bug, which was adressed

via extra triggers in OpenACS

* drop some leftover form ancient versions, were some

update scripts were missing

- bump version number of acs-content-repository 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.
Bumping up version numbers to 5.9.0d1 for core packages on HEAD.

  1. … 24 more files in changeset.
Some time ago some plpgsql functions were changed in order to be compatible with pg 8.x, create scripts were modified but upgrade scripts were missing ( at least i couldn't find them) http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Ajeffd%3A20090210183154 . Bumping up package versions accordingly.

  1. … 7 more files in changeset.
- missing index and foreign key constraints on cr_item_publish_audit fixed

  1. … 2 more files in changeset.
Merged oacs-5-7 to HEAD

  1. … 167 more files in changeset.
Upgrade scripts contain the following changes:

- getting right name of triggers, following the pattern *_tr

- redefining funtion arguments for each function using define_function_args

- getting rid of unncesary backslashes, used for escaping, in some functions.

- redefinitions of content_type__refresh_trigger and content_type__drop_type in order to get rid of some 7.2 vs 7.3 querying.

  1. … 3 more files in changeset.
Bumping up version numbers for core packages to 5.8.0d1

  1. … 24 more files in changeset.
Adding a couple of attributes to make packages working with meta-data less

kludgey. PG-only with this commit, Oracle to follow.

  1. … 2 more files in changeset.
bumped version number to 5.7.0d3

Moved table building and column adding code from content repository to

kernel, so all objects can benefit. Part of the acs object management package

work.

  1. … 5 more files in changeset.
Upgrade scripts for changes on object metadata creation (adding automatic

table and column creation to base objects as well as CR object, object views,

etc).

  1. … 3 more files in changeset.
Bumped version numbers to 5.6.0d1

  1. … 23 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.
Implements TIP #142: Administration UI to manage mime types and extension map

  1. … 15 more files in changeset.
Make sure you always cascade when dropping the views or it will fail.

  1. … 2 more files in changeset.
Fix support for NULL table name in CR-derived object types

  1. … 4 more files in changeset.
Merged 5.5.1 to HEAD

  1. … 181 more files in changeset.