pg9.4b1: unhelpful error message when creating a collation

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg9.4b1: unhelpful error message when creating a collation
Date: 2014-05-25 07:17:24
Message-ID: alpine.DEB.2.10.1405250857040.6447@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matteo Beccati 2014-05-25 09:11:58 [PATCH] Replacement for OSSP-UUID for Linux and BSD
Previous Message Pavel Stehule 2014-05-25 05:53:15 proposal: ignore null fields in not relation type composite type based constructors