I run a SAS application that uses PostgreSQL. I’m working on enhancing my support for other languages. One of the things I noticed is that I’m getting my errors (say a unique key constraint) in English. This is expected. I know I’m not doing anything to change the locale.
I’d like to figure out how to get the errors in the user’s locale. I’m using JDBC to talk to the DB.
I looked at the documentation for localization and it appears that the locale for messages can be set for the database instance at startup by setting the LC_MESSAGES environment variable. I don’t want to have a different database instance for each language. Really, I’d just like a way of setting the locale prior to making a statement call.
I’ve looked at the SET command and the documentation for lc_messages(string) in section 18.10 of the manual and this doesn’t work because it requires Super User.
Is there a way to make this work? If not, is there an enhancement request queue I should submit this to?
George Sexton
MH Software, Inc.
303 438-9585
www.mhsoftware.com