• last updated 19 hours ago
Constraints: committers
Constraints: files
Constraints: dates
Made .xql file more consistent by using dot notation

OpenACS for PostgreSQL uses since the release of 5.10.0 the dot

notation for the SQL function acs_permission.permission_p() to ease

portability with Oracle.

In general, one has to be careful that during an upgrade from an older

OpenACS version (e.g. 5.9.*) directly to 5.10.1 to upgrade process

does not depend on the dot notation, otherwise the upgrade will fail.

One should be safe for most UI functions in this respect.

Cleanup long deactivated code

  1. … 1 more file in changeset.
fix performance problem with pg12 by using permission_p_recursive_array

change queries on site-node tree from tree_sortkey to recursive queries

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

  1. … 7834 more files in changeset.
.xql overhaul:

- removed misleading sql-statements from db_* calls, which were

ignored due .xql files

- removed bug where same query name was used in a single proc

with different intended sql queries, but the same was picked

up from the .xql file due to the name

- removed multiple entries of same query name from .xql files

(e.g. the entry "package_create_attribute_list.select_type_info" was

7 (!!!) times in a single .xql file)

- removed redundant queries for unsupported versions of the dbms

- added missing xql entries for db-backends, where other db-specific

queries exists (e.g. added an entry to -oracle.xql, where an entry

existed in -postgres.xql)

  1. … 70 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.
- fix gor bug #3174. subsites disappeared from sitemap, when a hard coded value was surpassed

  1. … 1 more file in changeset.
Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

  1. … 14 more files in changeset.
Made sure we do not display all subsites. Bad idea especially when dealing with dotFolio

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

  1. … 598 more files in changeset.
substantially speed up /admin/site-map/ on postgres (and probably oracle but I did not test it)

  1. … 2 more files in changeset.
removing the package_types query that has been encapsulated in the proc apm_application_new_checkbox (forgot to do this earlier)

  1. … 1 more file in changeset.
Added package type to the site map, making it easier to figure out how your site's structured, when instance name isn't the same as package name

  1. … 2 more files in changeset.
site-map now uses the site node apis where possible

  1. … 37 more files in changeset.
patch 136 applied

  1. … 1 more file in changeset.

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 18 more files in changeset.

Switched tree-based queries to a tree-using form, which will greatly enhance


  1. … 26 more files in changeset.
Fix queries

Port queries

  1. … 29 more files in changeset.
Port queries

    • -0
    • +74
  1. … 28 more files in changeset.