| From: | Doug Silver <dsilver(at)urchin(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | errors using COPY from MySQL data |
| Date: | 2003-04-02 00:40:15 |
| Message-ID: | 200304011639.53436.dsilver@urchin.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm sure this has been covered before, but I'm quickly getting frustrated
copying 100 lines at a time. I did a data dump from a MySQL table, one of
the fields is a timestamp which it output as '20020816:23:44', so I changed
it to '20020816 23:44'. But, I'm now consistently getting this error:
data=# copy data from '/tmp/data.1';
COPY
(I copy/paste 100 lines in from the original file)
data=# copy data from '/tmp/data.1';
ERROR: copy: line 15, Bad timestamp external representation ''
(copy/paste the first 20 lines from the original, i.e. the same data just the
first 20 instead of all 100)
data=# copy data from '/tmp/data.1';
COPY
At first I was able to do 1000 lines at a time, but now it's down to 100 -- ok
that's not very scientific, but it doesn't matter if I delete line 15 (which
*looks* okay). Note the second time it didn't complain at all about line 15.
Considering I have ~20000 entries, I'm going to need a lot of Snickers ... ;)
PostgreSQL 7.3.2
TIA
-doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Renê Salomão | 2003-04-02 14:05:41 | Re: Postgres logs w/ Logrotate |
| Previous Message | Martijn van Oosterhout | 2003-04-02 00:19:49 | Re: Postgres logs |