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: 09 Jul
Commits this week: 0
Total Lines of Code (LoC): 596
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 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep 2024
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./acs-permissions-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -255
    • +47
    ./acs-permissions-create.sql
  2. … 8099 more files in changeset.
Friday 02 Feb 2024
1:50 pm

gustafn

Silence potentially confusing warning during first installation

Options
    • -5
    • +5
    ./acs-permissions-create.sql
  2. … 2 more files in changeset.
Tuesday 29 Aug 2023
4:10 pm

gustafn

fixed typo

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 4 more files in changeset.
Saturday 08 Oct 2022
10:07 pm

gustafn

Cleanup of acs_object_context_index' and friends in creation scripts

This change completes the commit [1] from 2019, where the cleanup was performed

acs_object_context_index and its maintenance functions just as an update script.

This change addresses this also in the creation scripts and in packages, still

depending on the old functions.

[1] https://fisheye.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Ahectorr%3A20190708160122

Options
    • -250
    • +42
    ./acs-permissions-create.sql
  2. … 9 more files in changeset.
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.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 48 more files in changeset.
Friday 09 Sep 2016
9:56 am

gustafn

- Improved compatiblity with PostgreSQL before 9.2:

don't use SQL-language function names to reference parameters to

obtain compatibility for earlier PostgreSQL versions

(see https://www.postgresql.org/docs/9.2/static/release-9-2.html

item E.19.3.9.3)

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
Wednesday 06 Jul 2016
8:10 pm

gustafn

- improve source code documentation

Options
    • -1
    • +11
    ./acs-permissions-create.sql
3:47 pm

gustafn

- added new function acs_permission.permissions_all as replacement for acs_permssions_all

- removed all dependencies on acs_permssions_all in kernel (such that acs_object_paths and acs_object_context_index can be dropped for PostgreSQL)

Options
    • -2
    • +31
    ./acs-permissions-create.sql
  2. … 8 more files in changeset.
9:40 am

gustafn

- change language of function from plpgsql to sql to avoid mismatch

Options
    • -5
    • +3
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
Tuesday 05 Jul 2016
6:35 pm

gustafn

- 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

Options
    • -82
    • +188
    ./acs-permissions-create.sql
  2. … 12 more files in changeset.
Friday 01 Jul 2016
4:04 pm

gustafn

- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

- bump version number to 5.9.1d10

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

gustafn

- Slightly faster (around 10%) versions for the base permission query functions.

In the new versions the lookup of acs__magic_object_id was moved out of the loop.

Options
    • -175
    • +141
    ./acs-permissions-create.sql
  2. … 2 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.
Thursday 19 Apr 2007
12:15 pm

gustafn

bumping version numbers and create an additional index to speed up permission checking

Options
    • -1
    • +2
    ./acs-permissions-create.sql
  2. … 4 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.