• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improve spelling

  1. … 33 more files in changeset.
Add missing change in the data model from previous commit

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

  1. … 7834 more files in changeset.
Fix spelling errors

  1. … 49 more files in changeset.
- fix bug when updateing a user portrait, which was saved as "lob"

  1. … 2 more files in changeset.
- use consistently varchar(1000) for object_types

- bump version number to 5.9.1d19

  1. … 2 more files in changeset.
- add missing enumeration type to create script

- fix ambiguity for content_item__new in template__new

- add/update mime types for text/csv text/vcard, text/calendar

- bump version number to 5.9.1d17

  1. … 6 more files in changeset.
- Change text enumeration field "storage_type" in cr_items to native

SQL enumeration type

- bump version number to 5.9.1d15

  1. … 3 more files in changeset.
- fix install scripts

  1. … 1 more file in changeset.
Content-Repository Reform: reduce dependency on cr_child_rels and simplify content_item__del() via cascading delete operations

- remove manual deletion operations from content_item__del() via

* delete cr_child_rels via "ON DELETE CASCADE" on parent_id and child_id

* delete cr_item_rels via "ON DELETE CASCADE" on item_id

* delete acs_object_context_index entries via "ON DELETE CASCADE" on ancestor_id and object_id

* delete acs_objects entries via "ON DELETE CASCADE" on context_id

- remove manual deletion operations for symlinks amd journal entries,

since db constrains handle the deletion already

- use cr_items.parent_id instead of cr_child_rels to determine direct children

of items

- remove deletion trigger for content search content_search__dtrg

since "ON DELETE CASCADE" removes entries already

  1. … 3 more files in changeset.
Content-Repository Reform : Reduction of number of functions in

the content repository for PostgreSQL by using using argument defaults

(while providing compatibility for clients using old versions):

- reduced number of versions of content_item__new from 12 (!) to 6 by using defaults

- commented differences

- commented arguments of plpgsql functions with long argument lists

- reduced code duplication by basing one version of content_item__new/17 directly on /20

- marking on version of content_item__new/17 and content_item__new/6 as deprecated

- reduced number of versions of content_revision__new from 7 to 4 by using defaults

- commented differences

- marking on version of content_revision__new/7 as deprecated

- let automatically generated functions call directly content_revision__new/13

- remove space from automatically generated functions

- updated automatically generated functions for all types of the content repository

- reduced number of versions of image__new from 4 to 2by using defaults

- reduced number of versions of image__new_revision from 2 to 1 by using defaults

  1. … 7 more files in changeset.
- follow naming conventions proposed by regression test

- bump version number

  1. … 3 more files 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.
- use external command "find" instead of tcllib package fileutil for speed and better filtering

- add index for much quicker reverse lookup file names in the content repository

  1. … 6 more files in changeset.
*** empty log message ***

make sure we exclude null paths from cr_files_to_delete

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

  1. … 2 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.
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.
Fixed a problem with the deletion of lob.sql-based ("pseudo-lob") binary

storage.

  1. … 2 more files in changeset.
switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

  1. … 8 more files in changeset.
Merged from 5.4.2

  1. … 283 more files in changeset.
Made naming constraints follow our standard so PG core AA tests won't bitch

  1. … 1 more file in changeset.
Remove unecessary upgrades.

Fix RI trigger now that we require PG 8 we don't need the workaround in

cr_folders.

  1. … 4 more files in changeset.
Support for relative file locations which might even reside on a windows drive and therefore start with d:\

  1. … 6 more files in changeset.
Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

  1. … 324 more files in changeset.
Update default template to use text instead of content tag to property grab

text from filesystem stored revisions.

  1. … 1 more file in changeset.
Correction of name constraint

  1. … 4 more files in changeset.