Re: COPY FROM is not 8bit clean - Mailing list pgsql-bugs

From Tom Lane
Subject Re: COPY FROM is not 8bit clean
Date
Msg-id 27359.1014699457@sss.pgh.pa.us
Whole thread Raw
In response to COPY FROM is not 8bit clean  (Darcy Buskermolen <darcy@ok-connect.com>)
List pgsql-bugs
Darcy Buskermolen <darcy@ok-connect.com> writes:
> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
> delimiter and ends up with parse errors when trying to do the insert

Are you perhaps operating in a multibyte encoding in which \254 is
just the first byte of a multibyte character?

I'm not sure what we do in such a case, and even less sure what we
should do ... but I am entirely prepared to believe that we don't
do the Right Thing ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Darcy Buskermolen
Date:
Subject: COPY FROM is not 8bit clean
Next
From: Tatsuo Ishii
Date:
Subject: Re: COPY FROM is not 8bit clean