Postgres Pro
Downloads
Home   >   mailing lists

Thread: [BUGS] Bug: CREATE COLLATION fails on Windows when used with POSIX

[BUGS] Bug: CREATE COLLATION fails on Windows when used with POSIX

From
Murtuza Zabuawala
Date:
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,
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