locales and indexes. 
Author Message
 locales and indexes.


> I ran into trouble with all my indexes when i upgraded postgresql from
> 7.0.2 to 7.0.2 with locales. I did not really found where the problem
> was but the indexes created before were messing un all the queries using
> them.
> The thing i did was drop/create with my indexes, but it shouldn't be
> necessary to do so, isn't it ?

If you're using locale support, it's essential to make sure the
postmaster is started with the same LOCALE environment variables
every time.  Otherwise you are redefining the sort order of indexes
every time you change the environment, which is a one-way ticket
to messed-up indexes.

We've heard from several people who made this mistake in the form of
sometimes starting the postmaster from the command line and sometimes
from a boot script.  Unfortunately their login environment wasn't like
the environment supplied by the boot script :-(

There is a TODO item to cause the postmaster always to adopt the LOCALE
settings that were in force when initdb ran, but it doesn't seem to be
very high priority for anyone... for now, just be careful.

                        regards, tom lane

Tue, 29 Apr 2003 23:26:32 GMT
 [ 1 post ] 

 Relevant Pages 

1. Locale and C Locale

2. to --enable-locale or not to --enable-locale?

3. OS locale files and Informix locale: any connection?

4. Locale and C Locale

5. Bug in index scans with Locale support enabled

6. Progress report on locale safe LIKE indexing

7. Bug in index scans with Locale support enabled

8. This locale setting will prevent use of index optimization for

9. Indices en tablas locales

10. Progress report on locale safe LIKE indexing

11. INDEX( index, index, ... )

12. UNICODE LOCALE problem when restoring

Powered by phpBB® Forum Software