| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problems transfering databases |
| Date: | 2001-08-22 14:34:52 |
| Message-ID: | 3608.998490892@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> writes:
> 'sql:2001-08-21db.out:5: ERROR: copy: line 1, Bad abstime external
> representation '\N
> psql:2001-08-21db.out:5: PQendcopy: resetting connection
Given the weird line-wrapping of the message, I'm going to bet that the
problem is that newlines in the dump file have gotten converted to DOS
format (ie, \n became \r\n), and COPY is unhappy because it sees the \r
as part of the data. When it echoes the data it didn't like, the
presence of the \r messes up the format of the error message.
Not sure *how* that happened in a Linux-to-Solaris transfer, though;
what tool did you use to transfer the dump file?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | newsreader | 2001-08-22 15:03:01 | Re: FTI is really really slow; what am I doing wrong? |
| Previous Message | Tom Lane | 2001-08-22 14:21:50 | Re: add, subtract bool type |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jefim Matskin | 2001-08-22 15:10:45 | odbc + unix sockets |
| Previous Message | Tom Lane | 2001-08-22 13:59:22 | Re: ODBC connection stopped working. |