Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > It's a pity that attempting to specify an encoding other than the safe > one when using a non-template0 database doesn't cause the CREATE > DATABASE command to fail with an error. Huh? regression=# create database foo lc_ctype = 'en_US.utf8' encoding = 'latin1'; ERROR: encoding LATIN1 does not match locale en_US.utf8 DETAIL: The chosen LC_CTYPE setting requires encoding UTF8. As best I can tell, the OP is complaining exactly because it did fail, in contrast to pre-8.4 versions that let him create unsafe combinations. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
