PgAdmin 4 ver. 1.5 - no error messages

Question

I am using pgAdmin 4 ver. 1,5. When I run an SQL query with some problems (for example, a column or table does not exist), I can only see the message "Query returned successfully", but I do not see an error message.

pgAdmin III 1.22.2

However, pgAdmin III explicitly displays SQL error messages in the same situation. Is there an option in pgAdmin 4 to enable error messages? Or is it just a mistake?

Answer 1

The problem is caused by non-English encoding.

I ran into this problem throughout the entire version 4. The psql command-line tool is also damaged (it spills out incorrect messages instead of error messages).

Fix: open the postgresql.conf file in your database directory. Find and comment on these lines, in my case I had to destroy the Russian language:

#lc_messages = 'Russian_Russia.1251' # locale for system error message # strings #lc_monetary = 'Russian_Russia.1251' # locale for monetary formatting #lc_numeric = 'Russian_Russia.1251' # locale for number formatting #lc_time = 'Russian_Russia.1251' # locale for time formatting # default configuration for text search #default_text_search_config = 'pg_catalog.russian' 

If you still want to see localized messages, you can try the sqlectron app , it seems like this is a good backup tool for the clumsy pgAdmin4.

Answer 2

I just install the latest version 4.3 in the root directory of pgadmin, fixed the problem .....

Answer 3

This can be fixed by installing the pgAdmin language pack if you are using Linux. At least for me this solved the problem.

Answer 4

The problem is solved by changing the following parameters from non-English to English.

lc_messages = 'English_United States.1252' # locale for reporting a system error # strings lc_monetary = 'English_United States.1252' # locale for monetary formatting lc_numeric = 'English_United States.1252' # locale for formatting numbers lc_time = 'English_United States.1252 '# locale for time formatting