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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jmuise(at)esri(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols
Date: 2017-05-19 17:02:47
Message-ID: 3637.1495213367@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jmuise(at)esri(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Justin Muise 2017-05-19 17:08:35 Re: BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols
Previous Message pistole 2017-05-19 16:46:53 BUG #14663: Unexpected rounding changes for money type divided by bigint