Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails witherror, "invalid name syntax" when using Japanese symbols

Поиск
Список
Период
Сортировка
От Justin Muise
Тема Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails witherror, "invalid name syntax" when using Japanese symbols
Дата
Msg-id a275f08a973349e58dbf34000a77038c@RED-INF-MXMB-P1.esri.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi Tom,

Just wanted to see if here was any additional information/testing you required from me, and if you are still reviewing
thisissue. 

Thanks,

Justin

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, May 19, 2017 10:44 AM
To: Justin Muise <JMuise@esri.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using
Japanesesymbols 

Justin Muise <JMuise@esri.com> writes:
> Thank you for your quick response! Please see the attached image.

Hm.  If I'm reading that correctly, you've got encoding set to UTF8 but the OS is going to think the encoding is
WIN1252,which will likely affect the behavior of isspace(), which'd successfully break this function.  I'm not sure how
thesystem allowed you to do that. 

I wonder though whether it wouldn't be better for SplitIdentifierString to use scanner_isspace() rather than isspace().
That would cause it to not treat things like   as whitespace, but maybe that's OK. 
        regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] [BUGS] Concurrent ALTER SEQUENCE RESTART Regression
Следующее
От: Emre Hasegeli
Дата:
Сообщение: Re: [BUGS] BUG #14637: Tests fail with pl_PL.UTF-8 locale