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

upgrade-5.8.0d3-5.8.0d4.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 2
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 171
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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 22 Oct 2018
7:47 pm

gustafn

fix issue #3360; probably a problem that shows up with pg10.

Options
    • -0
    • +3
    ./upgrade-5.8.0d3-5.8.0d4.sql
12:41 pm

gustafn

make checking of pg_version number more robust (backporting changes from head).

See also issue #3359

Options
    • -1
    • +2
    ./upgrade-5.8.0d3-5.8.0d4.sql
Wednesday 29 May 2013
11:41 am

victorg

on pg version 9.0 ( and lower ) the function string_to_array takes only two parameters.

Options
    • -1
    • +1
    ./upgrade-5.8.0d3-5.8.0d4.sql
  2. … 1 more file in changeset.
Tuesday 23 Apr 2013
5:23 pm

victorg

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

Options
    • -104
    • +161
    ./upgrade-5.8.0d3-5.8.0d4.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
    • -5
    • +3
    ./upgrade-5.8.0d3-5.8.0d4.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
    • -0
    • +116
    ./upgrade-5.8.0d3-5.8.0d4.sql
  2. … 14 more files in changeset.