OpenACS / openacs-4 / packages / acs-kernel / sql / postgresql

acs-permissions-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 804
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 01 Nov 2018
9:38 am

gustafn

improve comments and spelling

Options
    • -11
    • +12
    ./acs-permissions-create.sql
  2. … 4 more files in changeset.
Sunday 24 Dec 2017
2:10 pm

gustafn

Fix typos

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 12 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -205
    • +317
    ./acs-permissions-create.sql
  2. … 7834 more files in changeset.
Monday 27 Jul 2015
2:51 pm

antoniop

Removed exclusive lock from permission granting and revoking. Use exception handling or ignoring instead, as in Oracle codebase.

Options
    • -27
    • +11
    ./acs-permissions-create.sql
  2. … 2 more files in changeset.
Tuesday 23 Apr 2013
5:23 pm

victorg

Creating recursive version of permissions functions iff pg version is >= 8.4.

Options
    • -87
    • +131
    ./acs-permissions-create.sql
  2. … 3 more files in changeset.
Tuesday 02 Apr 2013
4:09 pm

victorg

Renaming parameters used on recursive query in order to avoid name clashing with function parameters ( seems to happen just in pg 8.4 ).

Options
    • -6
    • +4
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
1:05 pm

victorg

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.

Options
    • -10
    • +84
    ./acs-permissions-create.sql
  2. … 14 more files in changeset.
Thursday 07 Jul 2011
12:46 pm

gustafn

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

Options
    • -78
    • +167
    ./acs-permissions-create.sql
  2. … 54 more files in changeset.
Wednesday 10 Mar 2010
1:44 am

donb

1. Changed trigger functions from "opaque" to "trigger" to get rid of the

warnings during initial install (only for acs-kernel, there are a lot

elsewhere!)

2. Added "embeds" for postgresql and partially for oracle.

3. Added global parameters for postgresql and partially for oracle.

(oracle will be forthcoming shortly)

Options
    • -4
    • +4
    ./acs-permissions-create.sql
  2. … 29 more files in changeset.
Friday 13 Feb 2009
2:36 pm

gustafn

- Add two missing indices to improve performance of permission system

and the object context hierarchy significantly (these two indices

improved the performance of e.g. /projects/openacs/download/ and

/projects/openacs/download/one-revision?revision_id=2089636 by more

than a factor of 10; these indices are now among the most used on

openacs.org)

- Bump version number

Options
    • -1
    • +8
    ./acs-permissions-create.sql
  2. … 5 more files in changeset.
Monday 14 May 2007
10:30 pm

donb

Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 324 more files in changeset.
Friday 13 Apr 2007
11:38 pm

gustafn

create an additional index to speed up permission checking

Options
    • -1
    • +2
    ./acs-permissions-create.sql
  2. … 2 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -4
    • +4
    ./acs-permissions-create.sql
  2. … 13 more files in changeset.
Sunday 27 Feb 2005
2:21 am

donb

A variety of group oriented things, and finally added the definitions of

acs-objects package procs in PG so that we can use package_instantiate_object

and package_db_exec with them.

Options
    • -4
    • +7
    ./acs-permissions-create.sql
  2. … 10 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./acs-permissions-create.sql
  2. … 32 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 598 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -46
    • +16
    ./acs-permissions-create.sql
  2. … 30 more files in changeset.
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -318
    • +189
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
Sunday 23 Feb 2003
5:22 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -15
    • +3
    ./acs-permissions-create.sql
  2. … 4 more files in changeset.
6:58 am

danw

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.

Options
    • -151
    • +134
    ./acs-permissions-create.sql
Monday 17 Feb 2003
4:32 pm

jeffd

rollback Dons commit which should have gone in on 4.6 rather than HEAD

Options
    • -27
    • +185
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
Friday 14 Feb 2003
3:47 am

donb

More mucking around with the denormalized party_approved_member_map ...

Options
    • -185
    • +27
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
Thursday 30 Jan 2003
5:28 pm

danw

Modified permissions code to materialize acs_privilege_descendant_map view. Needed to speed up queries on acs_object_grantee_priv_map view.

Options
    • -1
    • +27
    ./acs-permissions-create.sql
Saturday 08 Dec 2001
2:17 am

donb

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

Options
    • -13
    • +15
    ./acs-permissions-create.sql
  2. … 62 more files in changeset.
Saturday 01 Dec 2001
6:55 pm

donb

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

Options
    • -3
    • +3
    ./acs-permissions-create.sql
  2. … 11 more files in changeset.
Wednesday 28 Nov 2001
7:39 pm

donb

First round of speedups for verious permissions issues. Key finding is that

the all_object_party_privilege_map is speedy in PostgreSQL and apparently in

Oracle, as well (having re-read some of the optimization threads).

Options
    • -36
    • +78
    ./acs-permissions-create.sql
  2. … 23 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +2
    ./acs-permissions-create.sql
  2. … 61 more files in changeset.
Saturday 01 Sep 2001
10:26 pm

donb

Install acs-service-contract ...

Options
    • -106
    • +8
    ./acs-permissions-create.sql
  2. … 2 more files in changeset.
Saturday 12 May 2001
11:48 pm

danw

fixed permissions problem for handling insertion of dup index values

Options
    • -11
    • +51
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
Tuesday 01 May 2001
5:11 pm

stevew

Speedy replacement for permission_p from Matthew Avalos

Options
    • -16
    • +71
    ./acs-permissions-create.sql