From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Tim Uckun <timuckun(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [BUGS] BUG #6034: pg_upgrade fails when it should not. |
Date: | 2011-05-23 12:26:27 |
Message-ID: | 201105231226.p4NCQRa03476@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Robert Haas wrote:
> On Sun, May 22, 2011 at 9:39 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > Tim Uckun wrote:
> >> pg_upgrade from 8.4 to 9.0 fails with the following error message.
> >>
> >> old and new cluster lc_collate values do not match
> >>
> >>
> >> on 8.4 show lc_collate outputs
> >> ------------
> >> ?en_NZ.utf8
> >> (1 row)
> >>
> >>
> >> on 9.0 it outputs
> >> ------------
> >> ?en_NZ.UTF8
> >> (1 row)
> >>
> >>
> >> So the difference seems to be in capitalization. Presumably they are the
> >> same collation with "different" names so it strikes me as odd that
> >> pg_upgrade would balk and refuse to upgrade the database.
> >>
> >> pg_upgrade should be able to tell that these are the same collations and go
> >> ahead with the upgrade.
> >>
> >> It also should give some indication of how to overcome the problem.
> >
> > [ Moved to hackers list.]
> >
> > Interesting. ?It can be easily fixed in the C code. ?Does anyone know of
> > an example where the case of the locale name is significant in
> > controlling the behavior?
>
> Uh, are we talking about locale, or collation?
>
> Because if it's collation, that seems certain to affect index contents.
Sorry, I was unclear. The question is whether the case of _name_ of the
locale is significant, meaning can you have two locale names that differ
only by case and behave differently?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Rasheed | 2011-05-23 14:02:51 | Seg-fault in format(text) |
Previous Message | Daniel Schreiber | 2011-05-23 10:27:57 | BUG #6035: server crash when executing recursive query (trying to allocate 16 Exabyte memory) |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2011-05-23 12:56:18 | Re: Isolation checks under MSVC |
Previous Message | Vaibhav Kaushal | 2011-05-23 12:17:52 | Re: Foreign memory context read |