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

rel-segments-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 17:08
Commits this week: 0
Total Lines of Code (LoC): 417
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -16
    • +17
    ./rel-segments-create.sql
  2. … 7834 more files in changeset.
Wednesday 31 Aug 2016
8:57 pm

gustafn

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

Options
    • -8
    • +5
    ./rel-segments-create.sql
  2. … 34 more files in changeset.
Friday 01 Jul 2016
6:44 am

gustafn

- rename attribute "tag" to "originating_rel_id" to avoid confusion

- Create an "identity relationship" (-10)

- Use the new identity relation instead of value "0" in party_approved_member_map

- Add a foreign key to avoid garbage in "originating_rel_id"

- Speed up referential integrity

- Improve get_func_definition() to return SQL function/procedure

definitions with argument names and defaults (contained just types before)

Options
    • -14
    • +18
    ./rel-segments-create.sql
  2. … 3 more files in changeset.
Friday 15 May 2015
4:26 pm

gustafn

- use "ot*" as alias for acs-object-types instead of "o*", which is used usually for acs-objects

Options
    • -21
    • +21
    ./rel-segments-create.sql
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
    • -56
    • +100
    ./rel-segments-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
    • -5
    • +5
    ./rel-segments-create.sql
  2. … 29 more files in changeset.
Monday 25 Sep 2006
7:21 pm

byronl

Correction of name constraint

Options
    • -3
    • +3
    ./rel-segments-create.sql
Friday 11 Aug 2006
11:58 pm

donb

Fixed some silly little things...

Options
    • -3
    • +3
    ./rel-segments-create.sql
  2. … 5 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-segments-create.sql
  2. … 721 more files in changeset.
Wednesday 27 Jul 2005
2:43 pm

maltes

More I18N

Options
    • -3
    • +3
    ./rel-segments-create.sql
  2. … 5 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
    • -5
    • +9
    ./rel-segments-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
    ./rel-segments-create.sql
  2. … 32 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -1
    • +1
    ./rel-segments-create.sql
  2. … 30 more files in changeset.
Monday 24 Mar 2003
9:30 pm

donb

Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

Options
    • -1
    • +1
    ./rel-segments-create.sql
  2. … 4 more files in changeset.
Thursday 13 Mar 2003
9:22 pm

donb

Migrated over changes to move some GIF resources into a common subdirectory

in the subsite package, so anyone who can read the main site can read

the images (previously you had to grant read privs to "/doc" explicitly

to get the graphics stored by acs-datetime to show up.

Options
    • -19
    • +25
    ./rel-segments-create.sql
  2. … 38 more files in changeset.
Wednesday 26 Feb 2003
3:21 am

donb

A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

Options
    • -19
    • +25
    ./rel-segments-create.sql
  2. … 15 more files in changeset.
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -161
    • +201
    ./rel-segments-create.sql
  2. … 17 more files in changeset.
Monday 17 Feb 2003
4:32 pm

jeffd

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

Options
    • -93
    • +160
    ./rel-segments-create.sql
  2. … 7 more files in changeset.
Sunday 16 Feb 2003
3:15 am

donb

Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

Options
    • -18
    • +35
    ./rel-segments-create.sql
  2. … 4 more files in changeset.
Saturday 15 Feb 2003
4:23 am

donb

First cut at Oracle perm rewrite and some whacking around on the PG version

Options
    • -19
    • +109
    ./rel-segments-create.sql
  2. … 10 more files in changeset.
Friday 14 Feb 2003
3:47 am

donb

More mucking around with the denormalized party_approved_member_map ...

Options
    • -160
    • +93
    ./rel-segments-create.sql
  2. … 7 more files in changeset.
Tuesday 11 Feb 2003
6:03 pm

donb

1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

Options
    • -160
    • +93
    ./rel-segments-create.sql
  2. … 23 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
    • -19
    • +14
    ./rel-segments-create.sql
  2. … 11 more files in changeset.
Wednesday 14 Mar 2001
3:07 pm

danw

fixed up some typos

Options
    • -3
    • +3
    ./rel-segments-create.sql
  2. … 4 more files 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
    • +327
    ./rel-segments-create.sql
  2. … 37 more files in changeset.