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

security-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 94
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
Tuesday 23 Apr
2:19 pm

gustafn

Fixed issue introduced in OpenACS 5.9.0

The old version did not insert a property value via the

sec_session_property__upsert() in PostgreSQL on the initial setting

(later updates were OK). The broken version was just adding a tuple

and left the "property_value" empty.

Many thanks to Jonathan Kelley for identifying the issue and reporting it.

Options
    • -16
    • +16
    ./security-create.sql
  2. … 2 more files in changeset.
Monday 21 Feb 2022
6:53 pm

gustafn

fix broken function_args definition

Options
    • -2
    • +2
    ./security-create.sql
  2. … 5 more files in changeset.
Tuesday 30 Jun 2015
11:08 pm

gustafn

- add stored procedure sec_session_property__upsert to address concurrency problems with

updates in sec_session_properties; implementation for PostgreSQL and

Oracle are added, latter is not tested.

- bump version number to 5.9.0d4

Options
    • -1
    • +44
    ./security-create.sql
  2. … 6 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -2
    • +2
    ./security-create.sql
  2. … 2547 more files in changeset.
Tuesday 26 Aug 2014
3:22 pm

gustafn

- change type of session_id as well to bigint in the create script

Options
    • -2
    • +2
    ./security-create.sql
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -2
    • +2
    ./security-create.sql
  2. … 13 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./security-create.sql
  2. … 32 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -1
    • +1
    ./security-create.sql
  2. … 30 more files in changeset.
Sunday 02 Mar 2003
11:32 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./security-create.sql
  2. … 53 more files in changeset.
Wednesday 19 Dec 2001
7:33 pm

donb

Renamed a column named "timestamp" in the security package because this is

now a reserved word in PG (correctly). I changed the Oracle version, too,

because I know that 9i has added the "timestamp" datatype and even if it

will accept it as a column name it's confusing.

I also changes postgresql.sql to load correctly under PG 7.1 and 7.2.

Options
    • -1
    • +1
    ./security-create.sql
  2. … 8 more files in changeset.
Saturday 28 Apr 2001
7:35 pm

donb

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

Options
    • -1
    • +1
    ./security-create.sql
  2. … 23 more files in changeset.
Sunday 08 Apr 2001
6:13 pm

danw

fixed acs_object tree trigger

Options
    • -1
    • +1
    ./security-create.sql
  2. … 2 more files in changeset.
Wednesday 14 Mar 2001
5:39 am

danw

initial import of acs kernel data-model ported to postgresql - implementation of tree queries completed for acs_object_types. Still need to finish tree queries for acs_privilege_hierarchy and rel_constraints tables.

Options
    • -0
    • +51
    ./security-create.sql
  2. … 37 more files in changeset.