Thread

1. Re: COPY FROM is not 8bit clean

   Darcy Buskermolen <darcy@ok-connect.com> — 2002-02-26T16:23:22Z

   Postgres was not compiled with Multibyte, if I replace the if (delimc == c)
   with if (strstr(delim,c)) it works as expected. This changes was
   implemented for performance reasons according to the CVS log.
   
   
   
   At 11:57 PM 2/25/02 -0500, Tom Lane wrote:
   >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
   >
   >
   
   

2. Re: COPY FROM is not 8bit clean

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-02-26T17:48:12Z

   Darcy Buskermolen <darcy@ok-connect.com> writes:
   > Postgres was not compiled with Multibyte, if I replace the if (delimc == c)
   > with if (strstr(delim,c)) it works as expected. This changes was
   > implemented for performance reasons according to the CVS log.
   
   Yeah, my error :-(.  See Tatsuo's reply for the correct fix.
   
   			regards, tom lane