pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: CR/LF conversion (was: import error)
4+ messages / 4 participants
[nested] [flat]
* Re: CR/LF conversion (was: import error)
@ 2003-01-28 14:08 Oliver Vecernik <vecernik@aon.at>
0 siblings, 2 replies; 4+ messages in thread
From: Oliver Vecernik @ 2003-01-28 14:08 UTC (permalink / raw)
To: pgsql-sql
Oliver Vecernik schrieb:
> Hi all!
>
> I'm trying to import a text file from Suunto Dive Manager. I've got
> following table structure:
Arghh ...
It's always the same problem with CR/LF conversions ...
After changing it to just LFs, everthing worked like a charm. Is there
an elegant way to handle this automatically?
Oliver
--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CR/LF conversion (was: import error)
@ 2003-01-28 15:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Oliver Vecernik <vecernik@aon.at>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2003-01-28 15:32 UTC (permalink / raw)
To: Oliver Vecernik <vecernik@aon.at>; +Cc: pgsql-sql
Oliver Vecernik <vecernik@aon.at> writes:
> It's always the same problem with CR/LF conversions ...
Ah, you figured it out. (Didn't see your followup right away because of
the changed subject line.)
> After changing it to just LFs, everthing worked like a charm. Is there
> an elegant way to handle this automatically?
There are plans to make COPY treat all common styles of newline alike.
We had to wait a release or two after taking the first step, though,
since it's an incompatible change.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CR/LF conversion (was: import error)
@ 2003-01-28 18:20 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Oliver Vecernik <vecernik@aon.at>
1 sibling, 0 replies; 4+ messages in thread
From: Achilleus Mantzios @ 2003-01-28 18:20 UTC (permalink / raw)
To: Oliver Vecernik <vecernik@aon.at>; +Cc: pgsql-sql
On Tue, 28 Jan 2003, Oliver Vecernik wrote:
> Oliver Vecernik schrieb:
>
> > Hi all!
> >
> > I'm trying to import a text file from Suunto Dive Manager. I've got
> > following table structure:
>
> Arghh ...
>
> It's always the same problem with CR/LF conversions ...
>
> After changing it to just LFs, everthing worked like a charm. Is there
> an elegant way to handle this automatically?
If your dates were german in the first place, keep them german during the
copy, otherwise you will
have wrong dates.
>
> Oliver
>
> --
> VECERNIK Datenerfassungssysteme
> A-2560 Hernstein, Hofkogelgasse 17
> Tel.: +43 2633 47530, Fax: DW 50
> http://members.aon.at/vecernik
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CR/LF conversion (was: import error)
@ 2003-02-02 08:14 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2003-02-02 08:14 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Oliver Vecernik <vecernik@aon.at>; pgsql-sql
We are supporting Win32 in 7.4, so it is very likely COPY will support
carriage returns the next release.
---------------------------------------------------------------------------
Tom Lane wrote:
> Oliver Vecernik <vecernik@aon.at> writes:
> > It's always the same problem with CR/LF conversions ...
>
> Ah, you figured it out. (Didn't see your followup right away because of
> the changed subject line.)
>
> > After changing it to just LFs, everthing worked like a charm. Is there
> > an elegant way to handle this automatically?
>
> There are plans to make COPY treat all common styles of newline alike.
> We had to wait a release or two after taking the first step, though,
> since it's an incompatible change.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-02-02 08:14 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-28 14:08 Re: CR/LF conversion (was: import error) Oliver Vecernik <vecernik@aon.at>
2003-01-28 15:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-02-02 08:14 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-28 18:20 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox