Tom Lane <[EMAIL PROTECTED]> writes:
> Victor Snezhko <[EMAIL PROTECTED]> writes:
>> 2) When I try to create a stored procedure to create table (e.g., for
>>creating table only if it doesn't already exist), it fails to
>>compile if i use cyrillic letter "х" (unicode id: 0x0445, utf-8
>>
Victor Snezhko <[EMAIL PROTECTED]> writes:
> LOG: plpgsql_convert_ident: ident=х, isspace array=f, isspace(0)=f
> LOG: plpgsql_convert_ident: ident=test_table, isspace array=ff,
> isspace(0)=f
Hmm, there was something wrong in my utf-8 cluster setup, I
re-attached it and now see that i
Some more infos: When I start and stop the postgres service, then very
rarely it happens that it works, particularly when I start and stop some
other services as well, such as the DNS caching client. But it is not
reproducible. Maybe a timing issue?
Can anybody reproduce this problem on Win XP
Victor Snezhko <[EMAIL PROTECTED]> writes:
> Hmm, there was something wrong in my utf-8 cluster setup, I
> re-attached it and now see that isspace indeed fails:
> LOG: plpgsql_convert_ident: ident=È, isspace array=ft, isspace(0)=f
Hm. Given that we've not seen this reported elsewhere, I wonder i
Tom Lane <[EMAIL PROTECTED]> writes:
>> Hmm, there was something wrong in my utf-8 cluster setup, I
>> re-attached it and now see that isspace indeed fails:
>> LOG: plpgsql_convert_ident: ident=х, isspace array=ft, isspace(0)=f
>
> Hm. Given that we've not seen this reported elsewhere, I wonder
Mac OS X is based on FreeBSD. I'm not sure if this is what you want, because I'm not in a Turkish locale, but ...#include #include int main(){ printf("isspace(0x85) returned %d\n", isspace(0x85));}produces:isspace(0x85) returned 0... on my Mac OS X 10.4.7 PPC box.On Sep 22, 2006, at 12:48 P
Victor Snezhko <[EMAIL PROTECTED]> writes:
> My FreeBSD lists a whole heck of characters:
> character 0x85 is a space
> character 0xa0 is a space
> character 0xaa is alphabetical
> character 0xb5 is alphabetical
> character 0xba is alphabetical
> character 0xc0 is alphabetical
> ... 0xc1-0xfe is a
I wrote:
> ... I think we need convert_ident to
> use a plpgsql_isspace() that accepts these and only these as spaces.
> Any high-bit-set byte is part of an identifier according to scan.l's
> rules, and convert_ident must have the same behavior regardless of locale.
> There may be related risks in
