ACK!!!!! must rember which MTA I'm useing...
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.. 


Mon, 25 Feb 2002 20:45:24 -0800
Darcy Buskermolen <darcy@ok-connect.com>
COPY FROM is not 8bit clean
> 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;

Tue, 26 Feb 2002 21:16:54 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: COPY FROM is not 8bit clean