OpenACS / openacs-4 / packages / ref-timezones

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 227,992
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 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -35711
    • +220868
    ./common/timezone-rules.dat
    • -505
    • +507
    ./common/timezones.dat
    • -4
    • +5
    ./postgresql/upgrade/upgrade-timezones.ctl
  4. … 8097 more files in changeset.
Sunday 19 Aug 2018
12:59 pm

gustafn

add update script, that was missed several years ago

Options
    • -0
    • +307
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -38611
    • +39200
    ./common/timezone-rules.dat
    • -550
    • +593
    ./common/timezones.dat
    • -2
    • +2
    ./postgresql/ref-timezones-create.sql
  4. … 7832 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
    • -13
    • +22
    ./postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql
  2. … 2547 more files in changeset.
Saturday 30 Mar 2013
7:50 pm

gustafn

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

- add missing function_args

Options
    • -97
    • +217
    ./postgresql/ref-timezones-create.sql
    • -7
    • +15
    ./postgresql/ref-timezones-drop.sql
    • -8
    • +18
    ./postgresql/upgrade/upgrade-0.2d-0.3.sql
    • -7
    • +17
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  5. … 16 more files in changeset.
Saturday 30 May 2009
10:40 pm

donb

Applied the 5.5.0a1 fix to the timezones control file, to match the new

data format.

Options
    • -4
    • +4
    ./oracle/01-timezone-rules.ctl
Thursday 19 Mar 2009
3:04 pm

victorg

- Solving problem for overlaping in changes for some european times.

- Loading more timezones.

Ref: http://alice.wu-wien.ac.at:8000/xowiki/timezone-updgrade

Options
    • -35931
    • +39960
    ./common/timezone-rules.dat
    • -518
    • +549
    ./common/timezones.dat
    • -0
    • +4
    ./postgresql/upgrade/upgrade-timezones.ctl
  4. … 2 more files in changeset.
Wednesday 13 Feb 2008
8:01 pm

donb

Some time, long long ago, the PSQL "\copy" command syntax change, but the

old syntax was accepted. As of PG 8.3, the old syntax is no longer allowed.

Options
    • -1
    • +1
    ./postgresql/00-timezones.ctl
    • -1
    • +1
    ./postgresql/01-timezone-rules.ctl
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -6
    • +6
    ./postgresql/ref-timezones-create.sql
    • -0
    • +19
    ./postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql
  3. … 720 more files in changeset.
Friday 07 Apr 2006
2:09 am

donb

file upgrade-5.2.2-5.2.3b1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.2-5.2.3b1.sql
Saturday 24 Jul 2004
5:10 pm

jeffd

timezone__get_abbrev invalid decl for p_time, bump version, upgrade

Options
    • -1
    • +1
    ./postgresql/ref-timezones-create.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 1 more file 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
    • -11
    • +12
    ./postgresql/ref-timezones-create.sql
  2. … 598 more files in changeset.
Wednesday 05 Nov 2003
9:34 pm

jeffd

changed the \copy commands to use the 7.2 format for psql as it is supported in 7.2 and 7.3

Options
    • -1
    • +2
    ./postgresql/00-timezones.ctl
    • -1
    • +2
    ./postgresql/01-timezone-rules.ctl
  3. … 6 more files in changeset.
Friday 31 Oct 2003
5:11 pm

jeffd

switch to using \\copy rather than copy since the backend typically

is not able to read the dat file because of permissions (or if it is

on a remote machine the file typically will not even exist).

bug #1033

Options
    • -3
    • +1
    ./postgresql/00-timezones.ctl
    • -4
    • +1
    ./postgresql/01-timezone-rules.ctl
  3. … 7 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +341
    ./oracle/upgrade/upgrade-0.3-0.4d1.sql
  2. … 23 more files in changeset.
Friday 03 Oct 2003
12:11 pm

jeffd

allow bulk loading with 7.2

Options
    • -2
    • +1
    ./postgresql/00-timezones.ctl
  2. … 6 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -3
    • +3
    ./oracle/ref-timezones-create.sql
    • -2
    • +2
    ./oracle/ref-timezones-drop.sql
  3. … 274 more files in changeset.
Tuesday 02 Sep 2003
5:27 pm

lars

Fixed upgrade for PG 7.2. Unfortunately, COPY has different syntax between 7.2 and 7.3

Options
    • -1
    • +4
    ./postgresql/00-timezones.ctl
    • -1
    • +4
    ./postgresql/01-timezone-rules.ctl
Monday 18 Aug 2003
5:24 pm

peterm

adding upgrade script for PG for version 0.3 that we forgot to add previously

Options
    • -0
    • +29
    ./postgresql/upgrade/upgrade-0.2d-0.3.sql
12:37 pm

lars

Added timezone__convert_to_locale proc for PG

Options
    • -1
    • +23
    ./postgresql/ref-timezones-create.sql
  2. … 1 more file in changeset.
Saturday 19 Jul 2003
12:18 am

donb

Forgot to change data control file to reference this package rather than

my test package ...

Options
    • -1
    • +1
    ./postgresql/01-timezone-rules.ctl
Thursday 17 Jul 2003
3:10 am

donb

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

Options
    • -527
    • +0
    ./common/ref-timezones-data.sql
    • -36045
    • +0
    ./common/ref-timezones-rules.sql
    • -35931
    • +0
    ./common/timezone-rules.csv
    • -0
    • +35931
    ./common/timezone-rules.dat
    • -521
    • +0
    ./common/timezones.csv
    • -0
    • +521
    ./common/timezones.dat
    • -1
    • +1
    ./oracle/00-timezones.ctl
    • -1
    • +1
    ./oracle/01-timezone-rules.ctl
    • -1
    • +1
    ./postgresql/00-timezones.ctl
    • -1
    • +1
    ./postgresql/01-timezone-rules.ctl
  11. … 24 more files in changeset.
Wednesday 16 Jul 2003
2:47 am

donb

Removed references to the old INSERT data initialization files in the

oracle version.

Options
    • -7
    • +1
    ./oracle/ref-timezones-create.sql
2:06 am

donb

Switching to the use of PostgreSQL's COPY command and Oracle's SQL*Loader

to load the data for this package. Much, much faster than a bazillion

INSERT statements.

Options
    • -521
    • +0
    ./common/00-timezones.csv
    • -35931
    • +0
    ./common/01-timezone-rules.csv
    • -0
    • +35931
    ./common/timezone-rules.csv
    • -0
    • +521
    ./common/timezones.csv
    • -0
    • +5
    ./oracle/00-timezones.ctl
    • -0
    • +11
    ./oracle/01-timezone-rules.ctl
    • -0
    • +1
    ./postgresql/00-timezones.ctl
    • -0
    • +1
    ./postgresql/01-timezone-rules.ctl
    • -7
    • +1
    ./postgresql/ref-timezones-create.sql
Sunday 13 Jul 2003
9:45 pm

donb

Moved csv files to match naming scheme that makes it easy to load in both

PG and Oracle - dd-table-name.csv where dd is the sequence number, used

to control the order in which table data is loaded.

Options
    • -0
    • +521
    ./common/00-timezones.csv
    • -0
    • +35931
    ./common/01-timezone-rules.csv
    • -521
    • +0
    ./common/ref-timezones-data.csv
    • -35931
    • +0
    ./common/ref-timezones-rules.csv
Saturday 17 May 2003
1:02 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +521
    ./common/ref-timezones-data.csv
    • -0
    • +35931
    ./common/ref-timezones-rules.csv
    • -47
    • +48
    ./postgresql/ref-timezones-create.sql
    • -7
    • +7
    ./postgresql/ref-timezones-drop.sql
  5. … 6 more files in changeset.
Saturday 29 Mar 2003
3:59 am

donb

file ref-timezones-data.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./common/ref-timezones-data.csv
3:59 am

donb

file ref-timezones-rules.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./common/ref-timezones-rules.csv
Thursday 23 Jan 2003
10:55 pm

peterm

rolling back bad commit. I committed installation timesaver changes to these files as part of my catalog file commit. Needless to say, Jeff the Gatekeeper Davis immediately spotted this mistake so that it could be corrected...

Options
    • -1
    • +520
    ./common/ref-timezones-data.sql
    • -1
    • +36016
    ./common/ref-timezones-rules.sql
Tuesday 21 Jan 2003
7:45 pm

peterm

I18N: committing all the message catalog files from the dotLRN translation server. Kudos to all our translators for this contribution.

Options
    • -520
    • +1
    ./common/ref-timezones-data.sql
    • -36016
    • +1
    ./common/ref-timezones-rules.sql
  3. … 333 more files in changeset.