sh> lsb_release -d
Description: Ubuntu 14.04 LTS
Codename: trusty
sh> uname -a
Linux sto 3.13.0-24-generic #47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014 x86_64
x86_64 x86_64 GNU/Linux
sh> locale -a
C
C.UTF-8
en_AG
en_AG.utf8
en_AU.utf8
en_BW.utf8
en_CA.utf8
en_DK.utf8
en_GB.utf8
en_HK.utf8
en_IE.utf8
en_IN
en_IN.utf8
en_NG
en_NG.utf8
en_NZ.utf8
en_PH.utf8
en_SG.utf8
en_US.utf8
en_ZA.utf8
en_ZM
en_ZM.utf8
en_ZW.utf8
fr_FR.utf8
POSIX
# with postgresql 9.4 installed from apt.postgresql.org.
sql> SELECT VERSION();
PostgreSQL 9.4beta1 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
sql> \dOS+
+- same list as above with "locale"
sql> SHOW lc_messages;
en_US.UTF-8
# stuff which is working as expected:
sql> CREATE COLLATION "test0" (locale='C');
CREATE COLLATION
sql> CREATE COLLATION "test1" (locale='en_US.UTF-8');
CREATE COLLATION
sql> CREATE COLLATION "test2" (locale='en_US.UTF8');
CREATE COLLATION
sql> CREATE COLLATION "test3" (locale='Foo');
ERROR: could not create locale "test3": No such file or directory
DETAIL: The operating system could not find any locale data for the locale name
"Foo".
# stuff which is incoherent:
sql> CREATE COLLATION "french" (locale='fr_FR.utf8');
ERROR: could not create locale "fr_FR.utf8": Success
The collation creation fails, not sure why yet. However, the "error ..
success" message is especially unhelpful.
Raising client_min_messages does not add more information.
I could not get the same error with 9.3.4.
--
Fabien.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
