Bug: CREATE COLLATION fails on Windows when used with POSIX

Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>

From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
To: pgsql-bugs@postgresql.org
Date: 2017-08-02T04:59:00Z
Lists: pgsql-bugs
Hi,

When we try to create new collation on windows using "POSIX" it fails.

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

*Error:*
ERROR: could not create locale "POSIX". No error

*Platform:*
Windows 2016 (64 bit)

*Version:*
Postgres 9.4

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
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company