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?

Attachment: signature.asc
Description: Digital signature

Reply via email to