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.

please the screenshot below)

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?

I'm not able to re-produce it, check screenshot https://ibb.co/hZonav — Murtuza Z, May 26 '17 at 10:18
@n33rma - and this exactly the message I would like to see in my pgAdmin 4 - unfortunately, I cannot. — Paweł Andrzej Hadam, Jun 05 '17 at 19:06
A screen from pgAdmin III https://i.stack.imgur.com/aaQ22.jpg — Paweł Andrzej Hadam, Jun 06 '17 at 05:26
Can you check if the table exists with the following query? SELECT EXISTS( SELECT * FROM information_schema.tables WHERE table_schema = '' AND table_name = 'non_existing_table' ); — Colwin, Jun 09 '17 at 05:01
@Colwin - this table does not exist, as I have never created it. That query returns FALSE. My problem is, that when I query that 'non_existing_table' from pgAdmin 4 I cannot see any error message. While pgAdmin III clearly says the 'non_existing_table' does not exist. — Paweł Andrzej Hadam, Jun 10 '17 at 11:25

score 13 · Answer 1 · answered Jun 22 '17 at 10:26

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.

Thank you - it helped. However, I needed to change only: **lc_messages = 'en_GB.UTF-8'**
and leave the other 3 parameters as they were before, when I created the database: **lc_monetary = 'Polish_Poland.1250' lc_numeric = 'Polish_Poland.1250' lc_time = 'Polish_Poland.1250'** It works now and I can see all messages in pgAdmin 4 as well. — Paweł Andrzej Hadam, Jul 04 '17 at 22:39
Commenting had no effect for me. I changed only **lc_messages** parameter: **lc_messages = 'en_US.UTF-8'**, then reloaded configuration - now works fine. — Spark13, Aug 17 '17 at 07:52

score 0 · Answer 2 · answered Apr 24 '18 at 07:15

0

I simply install the latest 4.3 version into the root directory of pgadmin, fixed the problem.....

answered Apr 24 '18 at 07:15

Shore

827
9
24

score 0 · Answer 3 · answered Jun 06 '18 at 19:38

0

This can be fixed by installing pgAdmin language package if you're using Linux. At least for me this fixed the problem.

answered Jun 06 '18 at 19:38

albert200000

335
3
13

score 0 · Answer 4 · answered Jul 11 '19 at 08:22

The problem is solved by changing the below parameters from nonenglish langauge to english.

lc_messages = 'English_United States.1252'          
       # locale for system error message strings
lc_monetary = 'English_United States.1252'          
             # locale for monetary formatting
lc_numeric = 'English_United States.1252'           
           # locale for number formatting
lc_time = 'English_United States.1252'              
           # locale for time formatting

pgAdmin 4 ver. 1.5 - no error messages

4 Answers4

Linked