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
