Re: locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: locale
Date: 2004-04-07 18:42:33
Message-ID: 26192.1081363353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I said:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> I was asking why we can't set it to a new static value when we create
>> the database.

> Because that would corrupt indexes on shared tables. (It might be
> possible to finesse that, but it's not a no-brainer.)

And even more to the point, it would corrupt non-shared indexes
inherited from template1. This could not be finessed --- AFAICS you'd
need to do the equivalent of a REINDEX in the new database to make it
work.

regards, tom lane

In response to

Responses

  • Re: locale at 2004-04-07 18:58:52 from Dennis Bjorklund

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-04-07 18:42:40 Re: locale
Previous Message Tom Lane 2004-04-07 18:40:41 Re: locale