Bug: CREATE COLLATION fails on Windows when used with POSIX

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug: CREATE COLLATION fails on Windows when used with POSIX
Date: 2017-08-02 04:59:00
Message-ID: CAKKotZQR5R+UuXy5mXNSYTA29f7NmnFse=SjwjVDSRr-HhtLhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-bugs by date

  From Date Subject
Next Message vinod.t.v 2017-08-02 06:34:19 BUG #14765: Recreating databases from copied files.
Previous Message twodragon72 2017-08-02 03:23:53 BUG #14764: #if HASH_DEBUG source in dynahash.c is fault.