How to disable Postgresql messages translation

Question

Hello,

Is there a way to disable the Postgresql translation of messages? I´m running my appl and Postgresql on a pt_BR Windows machine and when a exception is thrown the error message is translated to Portuguese, like:

Caused by: org.postgresql.util.PSQLException: ERRO: relação "unidade_federacao" não existe Posição: 25

I would like the messages to appear in English.

I´m using the driver postgresql-8.4-701.jdbc3.jar on a Java (with Hibernate) app.

thanks in advance, Fabrício Lemos

Answer 1

You could change lc_messages in postgresql.conf or just per database:

ALTER DATABASE dbname SET lc_messages=en_us;

See also the manual.