pgAdmin 4 ver. 1.5 - no error messages

Question

I use pgAdmin 4 ver. 1.5. When I run an SQL query that has some issues (e.g. a column or a table does not exist) I can only see a message saying "Query returned successfully" but I cannot see any error message.

pgAdmin III 1.22.2

However, pgAdmin III shows clearly SQL error messages in the same situation. Is there any option in pgAdmin 4 to turn the error messages on? Or it's just a bug?

Answer 1

An issue is caused by non-English encoding.

I've experienced this issue within whole version 4 line. psql command line tool is affected too (spits out invalid chars complains instead of error messages).

Fix: open postgresql.conf file in your database directory. Find and comment out these lines, in my case had to wipe out Russian:

#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 may want to try sqlectron app, it looks like to be nice backup tool for clumsy pgAdmin4.