On Thu, Oct 8, 2015 at 12:49 PM, Thomas Munro wrote:
> On Thu, Oct 8, 2015 at 5:52 AM, Peter Geoghegan
> wrote:
> > On Wed, Oct 7, 2015 at 6:25 AM, Tom Lane wrote:
> >> The only real way out of such a situation is to REINDEX affected
> indexes.
> >> Refusing to start the server not only doesn't
Thomas Kellerer wrote:
> I always thought that this is a major shortcoming (if not a bug) in Postgres
> that the collation support is left to the OS.
>
> Because it essentially means that that exactly the same query with exactly
> the same data might return a different result if run on d
On Wed, Oct 7, 2015 at 8:39 PM, Tom Lane wrote:
> 1. Being compatible with the operating system's collation behavior is a
> feature, not a bug. If nothing else, it allows us to tell people that
> if we sort data the same way that sort(1) does, then it's not a bug that
> we're not sorting the way
On Wed, Oct 7, 2015 at 8:06 PM, Thomas Munro
wrote:
>> I think we should bite the bullet and adopt ICU, without abandoning
>> support for OS locales for users that really need it (certainly, many
>> will need it initially when using pg_upgrade to get on to the first
>> version that happens to have
Peter Geoghegan writes:
> I think we should bite the bullet and adopt ICU,
I see absolutely nothing to recommend that course of action. Reasons not
to:
1. Being compatible with the operating system's collation behavior is a
feature, not a bug. If nothing else, it allows us to tell people that
On Thu, Oct 8, 2015 at 1:16 PM, Peter Geoghegan
wrote:
> On Wed, Oct 7, 2015 at 4:49 PM, Thomas Munro
> wrote:
>>> I agree that that would be almost as bad as carrying on, because there
>>> is no reason to think that the locale thing can easily be rolled back.
>>> That was my point, in fact.
>>
>
On Wed, Oct 7, 2015 at 4:49 PM, Thomas Munro
wrote:
>> I agree that that would be almost as bad as carrying on, because there
>> is no reason to think that the locale thing can easily be rolled back.
>> That was my point, in fact.
>
> I have contemplated a maintenance script that would track eithe
On Thu, Oct 8, 2015 at 5:52 AM, Peter Geoghegan
wrote:
> On Wed, Oct 7, 2015 at 6:25 AM, Tom Lane wrote:
>> The only real way out of such a situation is to REINDEX affected indexes.
>> Refusing to start the server not only doesn't contribute to a solution,
>> but makes it impossible to fix manual
On Wed, Oct 7, 2015 at 6:25 AM, Tom Lane wrote:
> The only real way out of such a situation is to REINDEX affected indexes.
> Refusing to start the server not only doesn't contribute to a solution,
> but makes it impossible to fix manually.
I agree that that would be almost as bad as carrying on,
Peter Geoghegan writes:
> At the risk of getting flamed: I think that this is a bug in
> PostgreSQL, not CentOS. I've said why I think that is at least once
> already [1]. Simply put, there is no justification for the belief that
> some people have that collations should be immutable, and there is
Peter Geoghegan schrieb am 07.10.2015 um 11:33:
> On Wed, Oct 7, 2015 at 2:20 AM, Bernd Helmle wrote:
>> The last day we've encountered an issue what i think is somewhat severe if
>> you want to do either OS upgrades with CentOS or even binary upgrades with
>> an existing PostgreSQL instance to a
--On 7. Oktober 2015 02:33:59 -0700 Peter Geoghegan
wrote:
>
> At the risk of getting flamed: I think that this is a bug in
> PostgreSQL, not CentOS. I've said why I think that is at least once
> already [1]. Simply put, there is no justification for the belief that
> some people have that colla
On Wed, Oct 7, 2015 at 2:20 AM, Bernd Helmle wrote:
> The last day we've encountered an issue what i think is somewhat severe if
> you want to do either OS upgrades with CentOS or even binary upgrades with
> an existing PostgreSQL instance to a new machine with locale de_DE.UTF-8
> and thus i'd li
The last day we've encountered an issue what i think is somewhat severe if
you want to do either OS upgrades with CentOS or even binary upgrades with
an existing PostgreSQL instance to a new machine with locale de_DE.UTF-8
and thus i'd like to share here.
Here are the details:
Originally a Postg
14 matches
Mail list logo
