Thread: PgAdmin3 bug on application_name
Platform: > $ uname -a && lsb_release -a > Linux pc 4.4.0-34-generic #53-Ubuntu SMP Wed Jul 27 16:06:39 UTC 2016 > x86_64 x86_64 x86_64 GNU/Linux > > Distributor ID: Ubuntu > Description: Ubuntu 16.04.1 LTS > Release: 16.04 > Codename: xenial > Language: LANG=ru_RU.UTF-8 Distribution: deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main Version: PgAdmin3 1.22.1 (Mar 23 2016, rev: REL-1-22-1), Latest from repo. PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit Bug: On query "SELECT application_name FROM pg_stat_activity;" return application name as "pgAdmin III - ???????????????????? ????????????????" If run from console: "$ export LANG=en_US.UTF8 && pgadmin3" and run query return true result "pgAdmin III - Browser, pgAdmin III - Query Tool" Problem in used locale ru_RU. https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#GUC-APPLICATION-NAME > application_name (string) The application_name can be any string of less than NAMEDATALEN characters (64 characters in a standard build). It is typically set by an application upon connection to the server. The name will be displayed in the pg_stat_activity view and included in CSV log entries. It can also be included in regular log entries via the log_line_prefix <https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#GUC-LOG-LINE-PREFIX> parameter. Only printable ASCII characters may be used in the application_name value. Other characters will be replaced with question marks (?). Sorry for bad english.
On Sun, Aug 14, 2016 at 08:04:58PM +0300, VJe@n wrote: > Platform: > > $ uname -a && lsb_release -a > Linux pc 4.4.0-34-generic #53-Ubuntu SMP Wed Jul 27 16:06:39 UTC 2016 > x86_64 x86_64 x86_64 GNU/Linux > > > > Distributor ID: Ubuntu > Description: Ubuntu 16.04.1 LTS > Release: 16.04 > Codename: xenial > > > Language: LANG=ru_RU.UTF-8 > Distribution: deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main > Version: PgAdmin3 1.22.1 (Mar 23 2016, rev: REL-1-22-1), Latest from repo. > PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) > 4.7.2, 64-bit You can get pgadmin support here: http://www.pgadmin.org/support/ -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +