Re: utf8 COPY DELIMITER? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: utf8 COPY DELIMITER?
Date
Msg-id 20070418.102442.00486914.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: utf8 COPY DELIMITER?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Tatsuo Ishii <ishii@postgresql.org> writes:
> > The message in question should be something like: 
> > "COPY delimiter must be a single ASCII character"
> 
> If we phrase it like that we should enforce it like that --- ie, reject
> high-bit-set characters.
> 
> But I'm a bit hesitant to do so, because it actually does work fine to
> use a high-bit-set character as a delimiter as long as client and server
> encodings are the same LATINx set.  We'd be taking away functionality
> for European users for no very good reason.
> 
> Is it worth going to the trouble of distinguish same-encoding and
> different-encoding cases and applying a looser check for the former
> case?

I think yes. Seems a good idea.

Even better, however, is fixing the CVS escaping and quoting I
think. Clearly it's a bug.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum vs statement_timeout
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum vs statement_timeout