Not able to create collation on Windows

Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>

From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>

To: PostgreSQL mailing lists <pgsql-general@postgresql.org>

Date: 2017-08-01T07:39:45Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Revert test case added by commit 1e165d05fe06a9072867607886f818bc255507db.
- 32ca22b02da9 10.0 landed
Second try at getting useful errors out of newlocale/_create_locale.
- 514f6132935d 10.0 landed
Try to deliver a sane message for _create_locale() failure on Windows.
- 1e165d05fe06 10.0 landed
Allow creation of C/POSIX collations without depending on libc behavior.
- f97256570f45 10.0 landed

Attachments

default collation.png (image/png)
error.jpg (image/jpeg)

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