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

site-nodes-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge with missing files

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

gustafn

merge from oacs-5-10

Options
    • -203
    • +44
    ./site-nodes-create.sql
  2. … 8099 more files in changeset.
Tuesday 01 May 2018
12:45 pm

gustafn

imporve spelling

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 6 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -37
    • +44
    ./site-nodes-create.sql
  2. … 7834 more files in changeset.
Monday 27 Apr 2015
5:28 pm

victorg

Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

Options
    • -6
    • +5
    ./site-nodes-create.sql
  2. … 520 more files in changeset.
Tuesday 23 Apr 2013
5:23 pm

victorg

Creating recursive version of permissions functions iff pg version is >= 8.4.

Options
    • -16
    • +65
    ./site-nodes-create.sql
  2. … 3 more files in changeset.
Tuesday 02 Apr 2013
1:05 pm

victorg

Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

Options
    • -22
    • +15
    ./site-nodes-create.sql
  2. … 14 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
    • -81
    • +162
    ./site-nodes-create.sql
  2. … 54 more files in changeset.
Wednesday 24 Nov 2010
7:58 pm

victorg

On my previous commit I added a not null constraint for name column on site_nodes, the problem is that main site node on oracle has a NULL name ( given the fact that empty strings are managed as NULL on Oracle ) therefore doesnt make sense to have such constraint.

Options
    • -2
    • +1
    ./site-nodes-create.sql
  2. … 3 more files in changeset.
4:21 pm

victorg

- Avoiding usage of coalesce function on site_nodes table columns in WHERE clause, this was leading to usage of sequencial scans which can be expensive when having a huge amount of site_nodes. Instead we go for isolation of the case when requestion a node with a null parent ( this would be the main site node ) and we use the = operator so the planner goes for a index scan.

- Adding not null constraint to site_nodes(name)

Options
    • -6
    • +13
    ./site-nodes-create.sql
  2. … 4 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
    ./site-nodes-create.sql
  2. … 29 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./site-nodes-create.sql
  2. … 32 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -1
    • +4
    ./site-nodes-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
    • -4
    • +1
    ./site-nodes-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
    • -1
    • +4
    ./site-nodes-create.sql
  2. … 96 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -10
    • +10
    ./site-nodes-create.sql
  2. … 598 more files in changeset.
Saturday 22 Jun 2002
10:54 pm

yon

fixing creation of site_node under postgres

Options
    • -0
    • +2
    ./site-nodes-create.sql
  2. … 2 more files in changeset.
Friday 07 Jun 2002
6:17 am

arjun

added site_nodes_parent_id_idx based on results from scalability testing

Options
    • -0
    • +1
    ./site-nodes-create.sql
  2. … 1 more file in changeset.
Sunday 09 Dec 2001
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -2
    • +7
    ./site-nodes-create.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -17
    • +13
    ./site-nodes-create.sql
  2. … 62 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
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 11 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
    ./site-nodes-create.sql
  2. … 23 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -7
    • +7
    ./site-nodes-create.sql
  2. … 12 more files in changeset.
Saturday 14 Apr 2001
7:12 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./site-nodes-create.sql
  2. … 8 more files in changeset.
Monday 09 Apr 2001
6:55 am

danw

fixed problem with infinite recursion on updates of tables with tree query triggers

Options
    • -1
    • +2
    ./site-nodes-create.sql
  2. … 4 more files in changeset.
Sunday 08 Apr 2001
1:41 pm

danw

fixed acs-install problems

Options
    • -1
    • +1
    ./site-nodes-create.sql
  2. … 2 more files in changeset.
Saturday 24 Mar 2001
1:34 am

danw

fixed up some tree queries

Options
    • -16
    • +33
    ./site-nodes-create.sql
  2. … 4 more files in changeset.
Wednesday 21 Mar 2001
6:46 am

danw

fixed exception messages, membership_rels delete trigger and composition_rels delete trigger

Options
    • -2
    • +1
    ./site-nodes-create.sql
  2. … 5 more files in changeset.
Tuesday 20 Mar 2001
7:02 am

danw

more cleanup

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 6 more files in changeset.
Sunday 18 Mar 2001
6:22 am

danw

fixed up a bunch of typos

Options
    • -2
    • +1
    ./site-nodes-create.sql
  2. … 8 more files in changeset.