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

rel-constraints-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge with missing files

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

gustafn

merge from oacs-5-10

Options
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 8099 more files in changeset.
Wednesday 14 Aug 2019
9:31 am

gustafn

improve spelling

Options
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 33 more files in changeset.
Tuesday 27 Mar 2018
2:22 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./rel-constraints-create.sql
  2. … 62 more files in changeset.
Sunday 24 Dec 2017
2:10 pm

gustafn

Fix typos

Options
    • -2
    • +2
    ./rel-constraints-create.sql
  2. … 12 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
    • -21
    • +37
    ./rel-constraints-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
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 29 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -7
    • +7
    ./rel-constraints-create.sql
  2. … 13 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 721 more files in changeset.
Wednesday 27 Jul 2005
2:43 pm

maltes

More I18N

Options
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 5 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./rel-constraints-create.sql
  2. … 32 more files in changeset.
Sunday 12 May 2002
10:57 pm

donb

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

Options
    • -45
    • +8
    ./rel-constraints-create.sql
  2. … 58 more files in changeset.
Sunday 21 Apr 2002
12:23 am

donb

Mostly fixed subsite issues with the PG version.

Options
    • -45
    • +8
    ./rel-constraints-create.sql
  2. … 2 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
    • -8
    • +4
    ./rel-constraints-create.sql
  2. … 11 more files in changeset.
Friday 20 Apr 2001
8:04 pm

danw

added index

Options
    • -0
    • +3
    ./rel-constraints-create.sql
6:29 am

danw

finished tree query support for rel_constraints

Options
    • -141
    • +124
    ./rel-constraints-create.sql
4:03 am

danw

added tcl variable support to db api

Options
    • -7
    • +24
    ./rel-constraints-create.sql
  2. … 3 more files in changeset.
Wednesday 18 Apr 2001
7:20 am

danw

partial fix of rel_constraints tree queries - more work required

Options
    • -9
    • +22
    ./rel-constraints-create.sql
  2. … 1 more file in changeset.
1:41 am

danw

added comments for default api values

Options
    • -4
    • +2
    ./rel-constraints-create.sql
  2. … 12 more files in changeset.
Saturday 24 Mar 2001
1:34 am

danw

fixed up some tree queries

Options
    • -25
    • +32
    ./rel-constraints-create.sql
  2. … 4 more files in changeset.
Sunday 18 Mar 2001
6:22 am

danw

fixed up a bunch of typos

Options
    • -45
    • +5
    ./rel-constraints-create.sql
  2. … 8 more files in changeset.
Thursday 15 Mar 2001
2:37 am

danw

added tree query support for acs_objects, site_nodes and fixed up tree queries for rel_constraints

Options
    • -86
    • +101
    ./rel-constraints-create.sql
  2. … 3 more files in changeset.
Wednesday 14 Mar 2001
3:07 pm

danw

fixed up some typos

Options
    • -3
    • +3
    ./rel-constraints-create.sql
  2. … 4 more files in changeset.
6:56 am

danw

added tree query support to the rel_constraints table

Options
    • -44
    • +145
    ./rel-constraints-create.sql
  2. … 1 more file in changeset.
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
    • +661
    ./rel-constraints-create.sql
  2. … 37 more files in changeset.