reassign 283849 gforge-db-postgresql thanks Hi Roland!
There are two different locales involved in PostgreSQL: The one of the client program (which can be set with LC_ALL), and the locale of the server, as demonstrated in a German locale: $ createdb test createdb: Erzeugung der Datenbank ist fehlgeschlagen: FEHLER: Datenbank »test« existiert bereits $ LC_MESSAGES=C createdb test createdb: database creation failed: FEHLER: Datenbank »test« existiert bereits The first part is a string from createdb itself, the second one a string sent by the server. So if you rely on server error messages in the C locale, please use psql instead of createdb: $ psql -c "create database template1" template1 FEHLER: Datenbank »template1« existiert bereits $ psql -c "set LC_MESSAGES = 'C'; create database template1" template1 ERROR: database "template1" already exists Thanks! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates?
signature.asc
Description: Digital signature