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 07:45:03 |
Message-ID: | 060d01c7c846$634439b0$c601a8c0@HP22720319231 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi.
>> 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.
Ah, yes.. I also agree that it has a user's confusion.
>
>> 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.
Um, It has a means to avoid now as surely you suggest......
Do you mean judgment material by the server side?
Sorry, I don't have a good idea now....
Regards,
Hiroshi Saito
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-07-17 09:33:08 | Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables... |
Previous Message | Neil Conway | 2007-07-17 07:32:47 | Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables... |