Not able to create collation on Windows

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Not able to create collation on Windows
Date: 2017-08-01 07:39:45
Message-ID: CAKKotZS-wcDcofXDCH=sidiuajE+nqHn2CGjLLX78anyDmi3gQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

I am trying to create collation on windows using default POSIX collation
with pgAdmin3 but I am getting error as shown in screenshot, Can someone
suggest how to fix this?

*Syntax:*
CREATE COLLATION public.test from pg_catalog."POSIX";

*Error:*
ERROR: could not create locale "POSIX". No error
(Refer screenshot for more information.)

On Postgres website, It is mentioned that POSIX is available on all
platform.
https://www.postgresql.org/docs/9.4/static/collation.html
*On all platforms, the collations named default, C, and POSIX are
available. Additional collations may be available depending on operating
system support.*

--
Regards,
Murtuza Zabuawala

Attachment Content-Type Size
image/png 34.9 KB
error.jpg image/jpeg 76.9 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2017-08-01 09:56:02 Shared Constants in PLPGSQL
Previous Message Murtuza Zabuawala 2017-08-01 07:21:02 Not able to create collation on Windows

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Verite 2017-08-01 07:45:03 Re: Crash report for some ICU-52 (debian8) COLLATE and work_mem values
Previous Message Amit Langote 2017-08-01 07:37:36 Re: foreign table creation and NOT VALID check constraints