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

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(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:23:10
Message-ID: 051901c7c83a$f2ce6760$c601a8c0@HP22720319231
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi ITAGAKI-san.

I think that it is use restrictions now....This is not a BUG.
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...
http://winpg.jp/~saito/pg_bug/copy_to.png
http://winpg.jp/~saito/pg_bug/copy_from.png
This SERVER_ENCODING is EUC_JP..:-(
This will be cleared by Shift_jis being supported as you suggested
before. Therefore, only psql to \copy of a client can do it now.
Probably, It will become the item of 'TODO' correctly.....

Is it different?
Or do you have another point?

Regards,
Hiroshi Saito

From: "ITAGAKI Takahiro"

>
> The following bug has been logged online:
>
> Bug reference: 3453
> Logged by: ITAGAKI Takahiro
> Email address: itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp
> PostgreSQL version: 8.2, 8.3dev
> Operating system: independent (especially Windows)
> Description: Error on COPY TO/FROM 'non-ascii-path'
> Details:
>
> When I set postgres a different character encoding from OS, COPY TO/FROM
> 'non-ascii-path' cannot open the path. The cause of the problem is that we
> pass path-strings encoded in the server encoding to open() directly without
> respect to the OS's native encodings.
>
> It will be worse in Windows East Asia versions; Postgres doesn't support
> their encodings as server encodings, so we cannot use non-ascii filenames
> there.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ITAGAKI Takahiro 2007-07-17 06:48:14 Re: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'
Previous Message Bruce Momjian 2007-07-17 04:54:51 Re: BUG #3387: mod on non-integer returns bad result