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 20 Aug
3:38 pm

gustafn

More function_args cleanup

- removed one more definition referring to a deleted function

- make sure we always get argument names via PostgreSQL

- aligned argument names with stubs (apm__set_value and apm__get_value)

- bumped version number to 5.10.1b7

Options
    • -8
    • +1
    ./acs-objects-create.sql
  2. … 4 more files in changeset.
Saturday 08 Oct 2022
10:07 pm

gustafn

Cleanup of acs_object_context_index' and friends in creation scripts

This change completes the commit [1] from 2019, where the cleanup was performed

acs_object_context_index and its maintenance functions just as an update script.

This change addresses this also in the creation scripts and in packages, still

depending on the old functions.

[1] https://fisheye.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Ahectorr%3A20190708160122

Options
    • -308
    • +1
    ./acs-objects-create.sql
  2. … 9 more files in changeset.
Wednesday 24 Mar 2021
10:51 am

gustafn

added constraint acs_objects_context_id_ck to avoid certain simple loops on context_ids

Options
    • -1
    • +10
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Friday 15 Nov 2019
3:43 pm

antoniop

Index acs_object's creation and modification date

Options
    • -1
    • +3
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Tuesday 03 Sep 2019
11:09 am

antoniop

Define an acs_object schema and use it to redefine acs_object__name using dot notation

Goal is to further reduce code divergency between Oracle and Postgres

Options
    • -7
    • +27
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Wednesday 14 Aug 2019
9:31 am

gustafn

improve spelling

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 33 more files in changeset.
Wednesday 19 Jun 2019
7:44 pm

gustafn

implementing feature request #3408: support for passing in null values to acs_object__set_attribute

Options
    • -9
    • +8
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Wednesday 11 Apr 2018
11:35 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 31 more files in changeset.
Wednesday 21 Feb 2018
3:00 pm

antoniop

Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

Options
    • -2
    • +11
    ./acs-objects-create.sql
  2. … 16 more files in changeset.
Sunday 24 Dec 2017
2:10 pm

gustafn

Fix typos

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 12 more files in changeset.
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.