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

upgrade-5.7.0d2-5.7.0d3.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 2
Last Commit: 03 Nov
Commits this week: 0
Total Lines of Code (LoC): 81
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 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 27 Mar 2018
2:22 pm

hectorr

Fix typos

Options
    • -3
    • +3
    ./upgrade-5.7.0d2-5.7.0d3.sql
  2. … 62 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
    ./upgrade-5.7.0d2-5.7.0d3.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
    • -0
    • +82
    ./upgrade-5.7.0d2-5.7.0d3.sql
  2. … 4 more files in changeset.