From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Not able to create collation on Windows |
Date: | 2017-08-01 07:39:45 |
Message-ID: | CAKKotZS-wcDcofXDCH=sidiuajE+nqHn2CGjLLX78anyDmi3gQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
image/png | 34.9 KB | |
error.jpg | image/jpeg | 76.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Uckun | 2017-08-01 09:56:02 | Shared Constants in PLPGSQL |
Previous Message | Murtuza Zabuawala | 2017-08-01 07:21:02 | Not able to create collation on Windows |
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2017-08-01 07:45:03 | Re: Crash report for some ICU-52 (debian8) COLLATE and work_mem values |
Previous Message | Amit Langote | 2017-08-01 07:37:36 | Re: foreign table creation and NOT VALID check constraints |