• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.

  1. … 1 more file in changeset.
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.
Fixed upgrade for PG 7.2. Unfortunately, COPY has different syntax between 7.2 and 7.3

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

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

  1. … 8 more files in changeset.