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

From Tom Lane
Subject Re: utf8 COPY DELIMITER?
Date
Msg-id 15238.1176850146@sss.pgh.pa.us
Whole thread Raw
In response to Re: utf8 COPY DELIMITER?  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: utf8 COPY DELIMITER?  (Tatsuo Ishii <ishii@postgresql.org>)
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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: utf8 COPY DELIMITER?
Next
From: Aidan Van Dyk
Date:
Subject: Re: Hacking on PostgreSQL via GIT