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;
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
