Not able to create collation on Windows
Started by Murtuza Zabuawalaover 8 years ago6 messages
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
Attachments:
default collation.pngimage/png; name="default collation.png"Download
�PNG
IHDR � f ��[W iCCPICC Profile H���T����+)������� �J�E@:�I�PB;���ZP����(�@�����>QYY6T���>��y��9���;����|3��@��%d�J d���Q�>���$&� r��,v��;22�cywz�r�R�����kQ�p�� ��S8y�l�G�5�a>