• last updated 40 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
updated missing data file using old data in cvs and sourcing the postgres upgrade sql file according to bug 2142

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

  1. … 7 more files in changeset.
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

  1. … 8 more files in changeset.
allow bulk loading with 7.2

  1. … 6 more files in changeset.
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)

  1. … 275 more files in changeset.
added missing acs-reference update info

    • -0
    • +11
    ./oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -0
    • +10
    ./postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
updated lat/long

    • -0
    • +66466
    ./common/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -0
    • +2
    ./oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -1
    • +6
    ./postgresql/ref-us-zipcodes-create.sql
    • -0
    • +5
    ./postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
deleted obsolete file

Moved these packages over to the use of bulk data loading rather than

slow inserts

    • -42201
    • +0
    ./common/ref-us-zipcodes-data.sql
    • -0
    • +42192
    ./common/us-zipcodes.dat
    • -0
    • +5
    ./oracle/00-us-zipcodes.ctl
    • -0
    • +1
    ./postgresql/00-us-zipcodes.ctl
    • -5
    • +1
    ./postgresql/ref-us-zipcodes-create.sql
  1. … 12 more files in changeset.
*** empty log message ***

    • -0
    • +26
    ./postgresql/ref-us-zipcodes-drop.sql
  1. … 1 more file in changeset.

mostly fixing reference data to work with PG ...

    • -42192
    • +42192
    ./common/ref-us-zipcodes-data.sql
    • -10
    • +11
    ./postgresql/ref-us-zipcodes-create.sql
  1. … 15 more files in changeset.
Initial Import

    • -0
    • +42201
    ./common/ref-us-zipcodes-data.sql
    • -0
    • +74
    ./oracle/ref-us-zipcodes-create.sql
    • -0
    • +34
    ./oracle/ref-us-zipcodes-drop.sql
    • -0
    • +66
    ./postgresql/ref-us-zipcodes-create.sql
  1. … 1 more file in changeset.