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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols
Дата
Msg-id 3637.1495213367@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14662: 'has_table_privilege()' function fails with error,"invalid name syntax" when using Japanese symbols  (jmuise@esri.com)
Ответы Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols  (Justin Muise <JMuise@esri.com>)
Список pgsql-bugs
jmuise@esri.com writes:
> The 'has_table_privilege()' function will return the error, "invalid name
> syntax", when the table used in the function contains certain Japanese
> characters. 

What character encoding are you using?  I'm suspicious that the underlying
problem is use of a non-ASCII-safe encoding (eg SJIS) on the client side,
combined with improper encoding conversion due to inaccurate
client_encoding and/or server_encoding settings.

FWIW, I can't reproduce any problem with your script here; but the
script arrived in what looks to be UTF8 encoding, and I suspect that
must not be what you were using when you hit the problem.
        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 по дате отправления:

Предыдущее
От: pistole@rhp.org
Дата:
Сообщение: [BUGS] BUG #14663: Unexpected rounding changes for money type divided bybigint
Следующее
От: Justin Muise
Дата:
Сообщение: Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols