From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Not able to create collation on Windows |
Date: | 2017-08-01 16:33:02 |
Message-ID: | CAKKotZTZw9dAicmxB6j5sApcehtP3_JWEJa-WnRJaix80peWYQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi Tom,
Yes, I was able to create collation using "C" instead of "POSIX" on windows,
CREATE COLLATION public.test from pg_catalog."C";
--
Regards,
Murtuza Zabuawala
On Tue, Aug 1, 2017 at 9:09 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> writes:
> > On 8/1/17 10:53, Tom Lane wrote:
> >> I think this is actually a bug, because the collations code clearly
> >> means to allow clones of the C/POSIX locales --- see eg lc_collate_is_c,
>
> > You seem to say that we should support a "POSIX" locale even on systems
> > where the C library does not support that. I'm not convinced about that.
>
> Uh, we already do. Note all the regression tests that unconditionally
> assume that the POSIX collation works. Also, I am confused by your
> apparent belief that there might somewhere be a version of libc that
> fails to provide C-locale-compliant behavior. Surely nobody would
> tolerate a version of strcmp() that fails to act per C spec.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-08-01 16:58:50 | Re: [GENERAL] Not able to create collation on Windows |
Previous Message | Dmitry Lazurkin | 2017-08-01 16:24:13 | Re: Perfomance of IN-clause with many elements and possible solutions |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Khandekar | 2017-08-01 16:33:40 | Re: map_partition_varattnos() and whole-row vars |
Previous Message | Tels | 2017-08-01 16:24:04 | Re: PL_stashcache, or, what's our minimum Perl version? |