• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- remove obsolete functions

  1. … 1 more file 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.
Eliminated acs_privilege_hierarchy_index in favor of using acs_privilege_descendant_map. In addition, rewrote trigger for creating acs_privilege_descendant_map as permissions creation was getting too slow on .LRN. .LRN has somewhere in the neighborhood of 90 entries in the privilege hierarchy, which is much higher than anticipated.

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.

Changed the representation of tree_sortkeys from "text" to "bit varying".

  1. … 62 more files in changeset.
added comments for default parameters

  1. … 10 more files in changeset.
partial work on content-test

  1. … 10 more files in changeset.
added tree queries

  1. … 6 more files in changeset.
more cleanup, added lob support for cr_revisions

  1. … 9 more files in changeset.
general cleanup of initial porting effort

  1. … 11 more files in changeset.
initial port to postgresql

    • -0
    • +349
    ./content-perms.sql
  1. … 7 more files in changeset.