acs-permissions-procs-postgresql.xql

  • last updated 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merged changes from the oacs-5-9 branch and resolved conflicts

    • -8
    • +8
    ./acs-permissions-procs-postgresql.xql
  1. … 7834 more files in changeset.
- Add SQL schema acs_permission to allow to call sql-functions for

Oracle and PostgreSQL in exactly the same way

- Move postgres permission function to the new neamespace and provide

stubs for backward compatibility

- New function permission::get_parties_with_permission

to support a restricted form of reverse lookup for permssions

in order to reduce the dependencies on

acs_object_party_privilege_map for PostgreSQL

- make upgrade scripts more robust (support repeated loading)

- bump verison number of acs-tcl to 5.9.1d9

- bump version number of acs-kernel to 5.9.1d11

    • -8
    • +8
    ./acs-permissions-procs-postgresql.xql
  1. … 12 more files 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.

    • -0
    • +7
    ./acs-permissions-procs-postgresql.xql
  1. … 14 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

    • -7
    • +0
    ./acs-permissions-procs-postgresql.xql
  1. … 2275 more files in changeset.
enhancemens on permission::permission_p_not_cached, working fast for 16K on PG7.4.1

    • -7
    • +0
    ./acs-permissions-procs-postgresql.xql
  1. … 2 more files in changeset.
request-processor-init.tcl

    • -1
    • +1
    ./acs-permissions-procs-postgresql.xql
  1. … 2 more files in changeset.
Slightly simplified some permissions checks, updated and documented ad_form

    • -2
    • +1
    ./acs-permissions-procs-postgresql.xql
  1. … 3 more files in changeset.
returned permission query to what it used to be

    • -3
    • +1
    ./acs-permissions-procs-postgresql.xql
  1. … 1 more file in changeset.
fixed pg queries

    • -14
    • +8
    ./acs-permissions-procs-postgresql.xql
cleaned up permissions api and added a few useful functions

    • -30
    • +40
    ./acs-permissions-procs-postgresql.xql
  1. … 2 more files in changeset.
factored a few permissions functions so that i can use them elsewhere

    • -1
    • +8
    ./acs-permissions-procs-postgresql.xql
  1. … 7 more files in changeset.

added obvious permission procs that weren't there before

    • -0
    • +18
    ./acs-permissions-procs-postgresql.xql
  1. … 2 more files in changeset.
Add missing query

    • -0
    • +7
    ./acs-permissions-procs-postgresql.xql

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

    • -0
    • +14
    ./acs-permissions-procs-postgresql.xql
  1. … 6 more files in changeset.