On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote: > > CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8) > > But then I get this: > > ERROR: could not create locale "nb_no.utf8": No such file or > directory > DETAIL: The operating system could not find any locale data for the > locale name "nb_no.utf8". > > I am using Fedora 21 and running locale -a shows these among the > locales: > > nb_NO > nb_NO.iso88591 > nb_NO.utf8 > > What am I missing? I see the error message from pgsql shows the > country code using lowercase, is that the problem? > Any ideas? Perhaps you need to use double quotes to preserve case: LOCALE = "nb_NO.utf8" -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general