| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Jakub Ouhrabka <jakub(dot)ouhrabka(at)comgate(dot)cz> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Corrupted index on 9.0.3 streaming hot standby |
| Date: | 2011-03-07 17:14:33 |
| Message-ID: | AANLkTi=A65DDQqfTx0t9xvMtoTi2znvL0sFu2VfgsQ4K@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Mar 7, 2011 at 9:15 AM, Jakub Ouhrabka
<jakub(dot)ouhrabka(at)comgate(dot)cz> wrote:
> for the archives: the root cause is locale. Both linux/debian servers were
> set to the same locale (cs_CZ.UTF-8) but there is slightly different
> definition of this locale on those systems - once numbers are before letters
> and another time numbers are after letters. Then the index appears to be
> broken...
>
> So definitely it's not a postgresql bug. It'd be nice if there are some
> safeguards against this mismatch, although I don't know how to do it...
Wow. That sucks. But thanks for reporting back on what happened.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SandraA | 2011-03-07 17:20:15 | Re: BUG #5899: Memory corruption when running psql |
| Previous Message | Kevin Grittner | 2011-03-07 16:03:19 | Re: BUG #5916: PGAdmin crash |