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

upgrade-0.6d2-0.6d3.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 2
Last Commit: 09:14
Commits this week: 0
Total Lines of Code (LoC): 259
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 30 Mar 2013
2:00 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -89
    • +55
    ./upgrade-0.6d2-0.6d3.sql
  2. … 16 more files in changeset.
Friday 29 Aug 2008
5:13 pm

daveb

More fixes to timespan calculaton to handle timezone (DST) spanning recurring events.

Options
    • -1
    • +46
    ./upgrade-0.6d2-0.6d3.sql
  2. … 2 more files in changeset.
Thursday 27 Sep 2007
3:21 pm

daveb

Fix problem with Daylight Saving Time when creating recurring

events. This works fine in Oracle because the timestamps don't have

timezones. In Postgresql when calculating the interval between events

for recurring events, we need to ignore the timezone to get the

correct result when the event crosses the Daylight Saving Time boundar.

Options
    • -0
    • +248
    ./upgrade-0.6d2-0.6d3.sql
  2. … 1 more file in changeset.