Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] Bug: CREATE COLLATION fails on Windows when used with POSIX - Mailing list pgsql-bugs

From Murtuza Zabuawala
Subject [BUGS] Bug: CREATE COLLATION fails on Windows when used with POSIX
Date
Msg-id CAKKotZQR5R+UuXy5mXNSYTA29f7NmnFse=SjwjVDSRr-HhtLhQ@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: twodragon72@gmail.com
Date:
Subject: [BUGS] BUG #14764: #if HASH_DEBUG source in dynahash.c is fault.
Next
From: vinod.t.v@outlook.com
Date:
Subject: [BUGS] BUG #14765: Recreating databases from copied files.