On Sun, 26 Apr 2015 12:43:57 +0200 Oliver Elphick <olly@xxxxxxxxxx> wrote: > 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" > Yes, that's it... :) Tried using double qoutes around both nb_NO and nb_NO.utf8 but that did not work but only around nb_NO.utf8 did the trick... Thx... :) BTJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
