Skip site navigation (1) Skip section navigation (2)

Re: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'
Date: 2007-07-17 06:48:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> wrote:

Hi Saito-san,

> I think that it is use restrictions now....This is not a BUG.

Sure, but I'd like to notice that we don't pay attention about
mismatch of PG and OS encodings.

> In Japan, use is restricted by the reason referred to as that server 
> encoding does not support all now. Then, It is Shift-jis encoding...

We don't have to support SJIS as a server encoding for this purpose.
We just need to have converter function like convert_server_to_os()
and use it when the path might include non-ascii characters. 
We can skip the function in usual file operations, for example, opening
a relation file, because paths under $PGDATA consists of only ascii
characters. We can minimize the performance impact from the conversion.

One problem is that we might not have enough information about OS
encodings, at least we cannot determine it using a portable method.
If we would know the native encoding, convertion itself will be easy.
For example, we can use convert('path-for-copy', server-encoding, 'SJIS')
in Japanese version of Windows.

> > Bug reference:      3453
> > Description:        Error on COPY TO/FROM 'non-ascii-path'
> > When I set postgres a different character encoding from OS, COPY TO/FROM
> > 'non-ascii-path' cannot open the path.

ITAGAKI Takahiro
NTT Open Source Software Center

In response to


pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-07-17 07:30:25
Subject: Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...
Previous:From: Hiroshi SaitoDate: 2007-07-17 06:23:10
Subject: Re: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group