| 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
| 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 |