Re: [BUGS] COPY FROM is not 8bit clean - Mailing list pgsql-hackers

From Darcy Buskermolen
Subject Re: [BUGS] COPY FROM is not 8bit clean
Date
Msg-id 3.0.32.20020226083000.02cc2550@mail.ok-connect.com
Whole thread Raw
List pgsql-hackers
This patch solves the problem.

At 09:16 PM 2/26/02 +0900, Tatsuo Ishii wrote:
>> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
>> delimiter and ends up with parse errors when trying to do the insert
>> 
>> 
>> What the ?? why dind' tthat go through with the body of the text.. *sigh*
>> I'll resend in the AM.. 
>
>Good catch. It's definitely a bug in copy command. Please try
>following patches (this is against 7.2).
>
>*** src/backend/commands/copy.c.orig    Tue Feb 26 21:11:05 2002
>--- src/backend/commands/copy.c    Tue Feb 26 21:11:35 2002
>***************
>*** 1024,1030 ****
>  CopyReadAttribute(FILE *fp, bool *isnull, char *delim, int *newline,
char *null_print)
>  {
>      int            c;
>!     int            delimc = delim[0];
>  
>  #ifdef MULTIBYTE
>      int            mblen;
>--- 1024,1030 ----
>  CopyReadAttribute(FILE *fp, bool *isnull, char *delim, int *newline,
char *null_print)
>  {
>      int            c;
>!     int            delimc = (unsigned char)delim[0];
>  
>  #ifdef MULTIBYTE
>      int            mblen;
>
>


pgsql-hackers by date:

Previous
From: domingo@dad-it.com (Domingo Alvarez Duarte)
Date:
Subject: Misbehavior of the query optimizer when using limit.
Next
From: "Art Nicewick"
Date:
Subject: Re: PostgreSQL 8.0 ??