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

acs-objects-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 26 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,438
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
    • -34
    • +22
    ./acs-objects-create.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -5
    • +5
    ./acs-objects-create.sql
  2. … 48 more files in changeset.
Wednesday 31 Aug 2016
8:19 pm

gustafn

- use dollar quoting for SQL comments

Options
    • -9
    • +9
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Friday 01 Jul 2016
10:57 am

gustafn

Remove type discrepancy introduced in 2002:

- acs_object_types.object_type has type varchar(1000), while

- acs_object_types.supertype has type varchar(100)

... several more data types are involved, using acs_object_types.object_type as foreign key

Options
    • -3
    • +3
    ./acs-objects-create.sql
  2. … 5 more files in changeset.
Friday 12 Feb 2016
8:56 am

gustafn

- fix install scripts

Options
    • -20
    • +8
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Monday 27 Jul 2015
2:52 pm

gustafn

- second part of Part 4 of OpenACS 5.9 agenda: get rid of tree_sortkey in acs-objects : getting rid of functions accessing acs_objects.tree_sortkey when creating new instances

- use variable names "ot1" and "ot2" instead of "o1" and "o2" when referring to object_types (and not objects)

Options
    • -133
    • +15
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Saturday 02 May 2015
6:47 pm

gustafn

- scalability reform part 1

* remove manual delete operations from acs_object__delete()

where update is as achieved automatcially via cascade operations

* improve documentation of source code

- bump version number to 5.9.0d2

Options
    • -26
    • +16
    ./acs-objects-create.sql
  2. … 2 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
    • -16
    • +8
    ./acs-objects-create.sql
  2. … 2547 more files in changeset.
Saturday 13 Sep 2014
11:46 am

gustafn

- fixing 2 more cases of still incorrect function argument names

Options
    • -6
    • +1
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
11:32 am

gustafn

- fix function args: names of arguments for postgres did not match names for oracle leading to potential portability problems

Options
    • -11
    • +8
    ./acs-objects-create.sql
  2. … 1 more file 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
    • -446
    • +693
    ./acs-objects-create.sql
  2. … 54 more files in changeset.
Sunday 17 Oct 2010
11:06 pm

donb

Merged oacs-5-6 to HEAD. HEAD now installs and passes all core tests. There

may still be some lingering problems due to my screwing up the oacs-5-6

branch earlier, I'll be looking into this later.

Options
    • -3
    • +3
    ./acs-objects-create.sql
  2. … 214 more files in changeset.
Monday 04 Oct 2010
11:59 pm

victorg

Changes for supporting postgresql 9.0:

- Avoiding usage of SQL reserved keywords on plpsql functions (plpsql lexer and parser were reworked).

- Fixing all those places on which FROM clause was automatically added by PG ( PG Config add_missing_from parameter was removed for this release of PG ).

Many thanks to Tracy Adams and Jeff Lu for providing first version of the patches.

Options
    • -9
    • +9
    ./acs-objects-create.sql
  2. … 16 more files in changeset.
Tuesday 08 Jun 2010
3:36 pm

donb

Somebody hosed this (probably me). Never caught because no one creates a

base object directly, just subtypes of acs_object with their own (correct)

definition of a new() function.

Options
    • -2
    • +2
    ./acs-objects-create.sql
Sunday 23 May 2010
3:30 pm

gustafn

- complete change to acs_objects_package_idx for new creates (see http://fisheye.openacs.org/changelog/OpenACS/?cs=oacs-5-6%3Agustafn%3A20100509112929)

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 1 more file 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
    • -8
    • +8
    ./acs-objects-create.sql
  2. … 29 more files in changeset.
Thursday 16 Jul 2009
2:40 am

donb

Added some missing attributes (more to go, though, damn core datamodel)

Options
    • -1
    • +17
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
Friday 26 Jun 2009
2:38 am

donb

Someone didn't realize that "foo;null" in define_function_args calls sets the

default value to 'null' not NULL...this has been there a long time ... maybe

even my fault, but I don't remember, it's ancient!

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 1 more file 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
    • +2
    ./acs-objects-create.sql
  2. … 5 more files in changeset.
Monday 17 Sep 2007
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -3
    • +2
    ./acs-objects-create.sql
  2. … 9 more files in changeset.
Saturday 15 Sep 2007
8:17 pm

gustafn

adding missing function args, fixing incorrect function args, including upgrade script

Options
    • -4
    • +4
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -3
    • +3
    ./acs-objects-create.sql
  2. … 13 more files in changeset.
Sunday 27 Feb 2005
8:23 pm

donb

Realized that I only need to define function args for the most verbose

form of acs_object__new, since package_instantiate_object handles

default values very nicely.

Options
    • -13
    • +1
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
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
    • -1
    • +52
    ./acs-objects-create.sql
  2. … 10 more files in changeset.
Monday 26 Jul 2004
2:21 pm

jeffd

preserve last_modified when explicitly updated, replaces acs_objects_last_mod_update_tr, bump version, upgrade scripts

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

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./acs-objects-create.sql
  2. … 32 more files in changeset.
Wednesday 17 Mar 2004
11:23 am

jeffd

minor typo prevented setting title even if provided in acs_object__new

Options
    • -1
    • +1
    ./acs-objects-create.sql
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -23
    • +159
    ./acs-objects-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -159
    • +23
    ./acs-objects-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -23
    • +159
    ./acs-objects-create.sql
  2. … 96 more files in changeset.