Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Not able to create collation on Windows - Mailing list pgsql-general

From Murtuza Zabuawala
Subject [GENERAL] Not able to create collation on Windows
Date
Msg-id CAKKotZS-wcDcofXDCH=sidiuajE+nqHn2CGjLLX78anyDmi3gQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Not able to create collation on Windows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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.
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


Attachment

pgsql-general by date:

Previous
From: Murtuza Zabuawala
Date:
Subject: [GENERAL] Not able to create collation on Windows
Next
From: Tim Uckun
Date:
Subject: [GENERAL] Shared Constants in PLPGSQL