HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

Query returned successfully when obvious error should occur

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
returnederrorqueryobviouswhenshouldoccursuccessfully

Problem

I have just installed postgresql and pgadmin on my Windows machine.
The problem is that whatever I enter in query window, it results with message:


Query returned successfully in XX msec.

Even, when query is obviously incorrect, and should cause an error, no error message is displayed - like on screenshot:

What am I doing wrong?

Solution

According to this ticket, the workaround is to set English language for messages in postgresql.conf, e.g.

lc_messages = 'en_GB.UTF-8'


See also this question on SO.

Code Snippets

lc_messages = 'en_GB.UTF-8'

Context

StackExchange Database Administrators Q#184694, answer score: 3

Revisions (0)

No revisions yet.