From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Cannot create collation? |
Date: | 2011-03-02 16:00:45 |
Message-ID: | 4D6E69AD.7080103@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 02.03.2011 14:58, hubert depesz lubaczewski wrote:
> When I try to create french collation, it seems to work, but fails soon:
>
> $ CREATE COLLATION french (LOCALE = 'fr_FR.UTF-8');
> CREATE COLLATION
Hmm, regardless of what's causing this, I wonder if we should check that
the locale works at CREATE COLLATION time, rather than fail when you try
to use it. Ie. add a call to pg_newlocale_from_collation() at the end of
DefineCollation(). Or would that just make it more difficult to restore
a database with invalid collations?
> $ select * from test3 order by x;
> ERROR: could not create locale "fr_FR.UTF-8": Success
Looks like newlocale() call returned 0, but didn't set errno. I don't
think that's supposed to happen. Which platform is this? Which operating
system and version?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2011-03-02 16:03:56 | Re: Cannot create collation? |
Previous Message | hubert depesz lubaczewski | 2011-03-02 15:58:23 | Re: Cannot create collation? |