Обсуждение: Strange benhavior of pgAdmin 9.8 on Windows
Team:
I installed pgAdmin 9.8 on Windows 10 to teach a class. the query tool, etc. seem to work well, but plsql tool shows a strange message, and commands like \d seem to hang
Microsoft Windows [Version 10.0.22000.2538](c) Microsoft Corporation. All rights reserved.C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime>"C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime\psql.exe" "host=localhost port=5432 dbname=dlh3 user=postgres sslmode=prefer connect_timeout=10" 2>>&1psql (18.0)WARNING: Console code page (437) differs from Windows code page (1252)8-bit characters might not work correctly. See psql referencepage "Notes for Windows users" for details.Type "help" for help.
When I type '\d', only the '\' shows until I hit return, but execution only starts after I hit return for the second time.
Standard plsql works fine.
For the purpose of teaching novices pgAdmin/Postgresql 18 it would be nice if I could use plsql in the context of pgAdmin - which used to work.
Thanks for thelp, Marc
---------------------------------------
Marc Linster; Marc@MarcLinster.com;
+352 621 430 156
Hi Marc,
I am able to reproduce the problem. But it is most likely because of the warning below. I'm checking if we can fix this.
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for detail
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for detail
On Sat, Oct 4, 2025 at 12:22 PM Marc Linster <marc@marclinster.com> wrote:
Team:I installed pgAdmin 9.8 on Windows 10 to teach a class. the query tool, etc. seem to work well, but plsql tool shows a strange message, and commands like \d seem to hangMicrosoft Windows [Version 10.0.22000.2538](c) Microsoft Corporation. All rights reserved.C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime>"C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime\psql.exe" "host=localhost port=5432 dbname=dlh3 user=postgres sslmode=prefer connect_timeout=10" 2>>&1psql (18.0)WARNING: Console code page (437) differs from Windows code page (1252)8-bit characters might not work correctly. See psql referencepage "Notes for Windows users" for details.Type "help" for help.When I type '\d', only the '\' shows until I hit return, but execution only starts after I hit return for the second time.Standard plsql works fine.For the purpose of teaching novices pgAdmin/Postgresql 18 it would be nice if I could use plsql in the context of pgAdmin - which used to work.Thanks for thelp, Marc---------------------------------------Marc Linster; Marc@MarcLinster.com;+352 621 430 156
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
OK, I'm getting the same issue even with chcp 1252. So that's not the problem.
On Tue, Oct 7, 2025 at 11:03 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Marc,I am able to reproduce the problem. But it is most likely because of the warning below. I'm checking if we can fix this.WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for detailOn Sat, Oct 4, 2025 at 12:22 PM Marc Linster <marc@marclinster.com> wrote:Team:I installed pgAdmin 9.8 on Windows 10 to teach a class. the query tool, etc. seem to work well, but plsql tool shows a strange message, and commands like \d seem to hangMicrosoft Windows [Version 10.0.22000.2538](c) Microsoft Corporation. All rights reserved.C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime>"C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime\psql.exe" "host=localhost port=5432 dbname=dlh3 user=postgres sslmode=prefer connect_timeout=10" 2>>&1psql (18.0)WARNING: Console code page (437) differs from Windows code page (1252)8-bit characters might not work correctly. See psql referencepage "Notes for Windows users" for details.Type "help" for help.When I type '\d', only the '\' shows until I hit return, but execution only starts after I hit return for the second time.Standard plsql works fine.For the purpose of teaching novices pgAdmin/Postgresql 18 it would be nice if I could use plsql in the context of pgAdmin - which used to work.Thanks for thelp, Marc---------------------------------------Marc Linster; Marc@MarcLinster.com;+352 621 430 156--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"