Re: copy from stdin; bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: copy from stdin; bug?
Date
Msg-id 20332.979525770@sss.pgh.pa.us
Whole thread Raw
In response to copy from stdin; bug?  (Rehak Tamas <rehak@sch.bme.hu>)
Responses Re: copy from stdin; bug?  (Rehak Tamas <rehak@sch.bme.hu>)
List pgsql-hackers
Rehak Tamas <rehak@sch.bme.hu> writes:
> i try to fill my table from a file using copy from stdin and postgresql
> corrupt the table. This happen if before the <tab> or end of line there
> is word that has a non-standard letter like o with accent and then an
> ordinary lette [a-z]. and now i reproduced this error if that o is at the
> and of the word. in these cases that word and the next one get into the
> same field...

Sounds to me like a multibyte-character translation problem.  What
encoding do you have set for the database?  What have you told it the
client encoding is?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: RE: primary keys
Next
From: Hiroshi Inoue
Date:
Subject: Re: SIGTERM -> elog(FATAL) -> proc_exit() is probably a bad idea