OpenACS / openacs-4 / packages / ref-timezones / sql / postgresql

00-timezones.ctl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 3
Last Commit: 16:43
Commits this week: 0
Total Lines of Code (LoC): 2
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./00-timezones.ctl
  2. … 1 more file 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
    ./00-timezones.ctl
  2. … 7 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
    ./00-timezones.ctl
  2. … 8 more files in changeset.
Friday 03 Oct 2003
12:11 pm

jeffd

allow bulk loading with 7.2

Options
    • -2
    • +1
    ./00-timezones.ctl
  2. … 6 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
    ./00-timezones.ctl
  2. … 1 more file in changeset.
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
    • -1
    • +1
    ./00-timezones.ctl
  2. … 33 more files in changeset.
Wednesday 16 Jul 2003
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
    • -0
    • +1
    ./00-timezones.ctl
  2. … 8 more files in changeset.