BUG #1929: Successful COPY fails with less records in CSV file

From: "Michael Rau" <michi(dot)rau(at)googlemail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1929: Successful COPY fails with less records in CSV file
Date: 2005-09-30 18:06:11
Message-ID: 20050930180611.E21CAF0D72@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1929
Logged by: Michael Rau
Email address: michi(dot)rau(at)googlemail(dot)com
PostgreSQL version: 8.0.3
Operating system: Windows Professional 5.1, Build 2600 Service Pack 2
Description: Successful COPY fails with less records in CSV file
Details:

The flat file c:/temp/import.csv (see below) is successfully
copied with the following command:

COPY STA.IA_STA_T_002_001 FROM 'c:/temp/import.csv' WITH DELIMITER '\t'

When the flat file contains for example only 29 records, the target
table contains no records. Can somebody put me to solution, please?

CONTENTS OF c:/temp/import.csv:
2005-01-31 \t 15:59:00 \t 2005-01-01 23:59:00 \t 1 \t 3 \t -390.1 \t "this
is ""positive"", and Samstag"
2005-01-03 \t 16:20:00 \t 2005-01-03 16:20:00 \t 5 \t -2 \t -77.58 \t "this
is ""negative"", and Montag"
2005-01-05 \t 14:10:00 \t 2005-01-05 14:10:00 \t 9 \t -5 \t 506.55 \t "this
is ""positive"", and Mittwoch"
2005-01-06 \t 14:59:00 \t 2005-01-06 14:59:00 \t 4 \t 0 \t 225.62 \t "this
is ""positive"", and Donnerstag"
2005-01-08 \t 03:29:00 \t 2005-01-08 03:29:00 \t 3 \t -4 \t 132.61 \t "this
is ""positive"", and Samstag"
2005-01-11 \t 22:23:00 \t 2005-01-11 22:23:00 \t 5 \t -4 \t 460.51 \t "this
is ""positive"", and Dienstag"
2005-01-15 \t 05:39:00 \t 2005-01-15 05:39:00 \t 8 \t -4 \t -312.24 \t "this
is ""negative"", and Samstag"
2005-01-15 \t 04:32:00 \t 2005-01-15 04:32:00 \t 8 \t 4 \t -10.01 \t "this
is ""negative"", and Samstag"
2005-01-15 \t 07:54:00 \t 2005-01-15 07:54:00 \t 3 \t 3 \t -42.5 \t "this is
""negative"", and Samstag"
2005-01-17 \t 00:53:00 \t 2005-01-17 00:53:00 \t 1 \t 1 \t -355.5 \t "this
is ""negative"", and Montag"
2005-01-17 \t 07:30:00 \t 2005-01-17 07:30:00 \t 7 \t 0 \t -404.64 \t "this
is ""negative"", and Montag"
2005-01-17 \t 22:28:00 \t 2005-01-17 22:28:00 \t 4 \t 4 \t -133.42 \t "this
is ""negative"", and Montag"
2005-01-17 \t 21:33:00 \t 2005-01-17 21:33:00 \t 1 \t -4 \t -78.84 \t "this
is ""negative"", and Montag"
2005-01-19 \t 01:57:00 \t 2005-01-19 01:57:00 \t 5 \t -3 \t 174.37 \t "this
is ""positive"", and Mittwoch"
2005-01-21 \t 11:37:00 \t 2005-01-21 11:37:00 \t 5 \t -2 \t 238.25 \t "this
is ""positive"", and Freitag"
2005-01-23 \t 01:15:00 \t 2005-01-23 01:15:00 \t 5 \t -3 \t 199.98 \t "this
is ""positive"", and Sonntag"
2005-01-26 \t 21:47:00 \t 2005-01-26 21:47:00 \t 9 \t -3 \t -141.86 \t "this
is ""negative"", and Mittwoch"
2005-01-30 \t 20:12:00 \t 2005-01-30 20:12:00 \t 8 \t -5 \t -138.41 \t "this
is ""negative"", and Sonntag"
2005-02-03 \t 09:05:00 \t 2005-02-03 09:05:00 \t 9 \t -4 \t -283.16 \t "this
is ""negative"", and Donnerstag"
2005-02-07 \t 17:29:00 \t 2005-02-07 17:29:00 \t 1 \t 2 \t 159.23 \t "this
is ""positive"", and Montag"
2005-02-07 \t 13:41:00 \t 2005-02-07 13:41:00 \t 3 \t -5 \t -117.08 \t "this
is ""negative"", and Montag"
2005-02-11 \t 21:24:00 \t 2005-02-11 21:24:00 \t 6 \t 1 \t 382.28 \t "this
is ""positive"", and Freitag"
2005-02-14 \t 03:30:00 \t 2005-02-14 03:30:00 \t 1 \t -4 \t -311.54 \t "this
is ""negative"", and Montag"
2005-02-14 \t 10:19:00 \t 2005-02-14 10:19:00 \t 1 \t -4 \t 175.26 \t "this
is ""positive"", and Montag"
2005-02-14 \t 02:45:00 \t 2005-02-14 02:45:00 \t 9 \t -1 \t 204.66 \t "this
is ""positive"", and Montag"
2005-02-14 \t 06:33:00 \t 2005-02-14 06:33:00 \t 5 \t -5 \t -145.34 \t "this
is ""negative"", and Montag"
2005-02-18 \t 10:13:00 \t 2005-02-18 10:13:00 \t 8 \t -5 \t -107.31 \t "this
is ""negative"", and Freitag"
2005-02-19 \t 07:10:00 \t 2005-02-19 07:10:00 \t 3 \t -2 \t 180.58 \t "this
is ""positive"", and Samstag"
2005-02-23 \t 03:07:00 \t 2005-02-23 03:07:00 \t 7 \t -5 \t 139.57 \t "this
is ""positive"", and Mittwoch"
2005-02-26 \t 13:52:00 \t 2005-02-26 13:52:00 \t 8 \t -1 \t -309.84 \t "this
is ""negative"", and Samstag"
2005-03-01 \t 06:32:00 \t 2005-03-01 06:32:00 \t 8 \t 1 \t -442.28 \t "this
is ""negative"", and Dienstag"
2005-03-04 \t 13:53:00 \t 2005-03-04 13:53:00 \t 9 \t 4 \t 21.68 \t "this is
""positive"", and Freitag"
2005-03-06 \t 19:38:00 \t 2005-03-06 19:38:00 \t 4 \t -4 \t -423.72 \t "this
is ""negative"", and Sonntag"
2005-03-31 \t 04:49:00 \t 2005-03-10 04:49:00 \t 2 \t 4 \t 541.57 \t "this
is ""positive"", and Donnerstag"
2005-03-10 \t 03:11:00 \t 2005-03-10 03:11:00 \t 3 \t -2 \t -236.53 \t "this
is ""negative"", and Donnerstag"
2005-03-11 \t 05:09:00 \t 2005-03-11 05:09:00 \t 8 \t -4 \t 48.59 \t "this
is ""positive"", and Freitag"
2005-03-12 \t 04:51:00 \t 2005-03-12 04:51:00 \t 8 \t 3 \t 78.02 \t "this is
""positive"", and Samstag"
2005-03-16 \t 13:11:00 \t 2005-03-16 13:11:00 \t 3 \t 1 \t 478.92 \t "this
is ""positive"", and Mittwoch"
2005-03-20 \t 03:09:00 \t 2005-03-20 03:09:00 \t 6 \t -2 \t 433.82 \t "this
is ""positive"", and Sonntag"
2005-03-20 \t 02:14:00 \t 2005-03-20 02:14:00 \t 9 \t 4 \t -444.59 \t "this
is ""negative"", and Sonntag"
2005-03-20 \t 09:49:00 \t 2005-03-20 09:49:00 \t 6 \t 2 \t 256.38 \t "this
is ""positive"", and Sonntag"
2005-03-24 \t 16:57:00 \t 2005-03-24 16:57:00 \t 2 \t 0 \t 144.58 \t "this
is ""positive"", and Donnerstag"
2005-03-26 \t 11:41:00 \t 2005-03-26 11:41:00 \t 5 \t -1 \t 42.71 \t "this
is ""positive"", and Samstag"
2005-03-29 \t 21:54:00 \t 2005-03-29 21:54:00 \t 7 \t 1 \t -240.02 \t "this
is ""negative"", and Dienstag"
2005-03-30 \t 02:39:00 \t 2005-03-30 02:39:00 \t 5 \t -3 \t -172.78 \t "this
is ""negative"", and Mittwoch"
2005-04-01 \t 08:04:00 \t 2005-04-01 08:04:00 \t 3 \t -4 \t 56.89 \t "this
is ""positive"", and Freitag"
2005-04-05 \t 04:11:00 \t 2005-04-05 04:11:00 \t 4 \t -5 \t 467.95 \t "this
is ""positive"", and Dienstag"
2005-04-06 \t 02:21:00 \t 2005-04-06 02:21:00 \t 6 \t 2 \t -287.9 \t "this
is ""negative"", and Mittwoch"
2005-04-07 \t 09:54:00 \t 2005-04-07 09:54:00 \t 1 \t -2 \t -255.83 \t "this
is ""negative"", and Donnerstag"
2005-04-08 \t 17:54:00 \t 2005-04-08 17:54:00 \t 6 \t -2 \t 394.92 \t "this
is ""positive"", and Freitag"
2005-04-08 \t 04:45:00 \t 2005-04-08 04:45:00 \t 1 \t 2 \t 509.47 \t "this
is ""positive"", and Freitag"
2005-04-11 \t 09:20:00 \t 2005-04-11 09:20:00 \t 4 \t -2 \t -349.27 \t "this
is ""negative"", and Montag"

Browse pgsql-bugs by date

  From Date Subject
Next Message Steve Peterson 2005-10-01 03:37:05 Re: Bug?: Text after right paren in query is ignored
Previous Message Alvaro Herrera 2005-09-30 14:58:40 Re: Bug?: Text after right paren in query is ignored