Re: Where is initdb?

Поиск
Список
Период
Сортировка
От Martín Marqués
Тема Re: Where is initdb?
Дата
Msg-id 1075218680.401688f806fc0@bugs.unl.edu.ar
обсуждение исходный текст
Ответ на Re: Where is initdb?  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Список pgsql-general
Mensaje citado por Jeremiah Jahn <jeremiah@cs.earlham.edu>:

> I think it's fair to say that out of the box and RPM install should not
> result in indexes not being used because the LANG is set to something
> other than 'C'. I'm all for reading the manual and tuning later, but
> that is something that can't be changed without a complete
> dump/initdb/restore. It's just always seemed kind of misleading to me..

The question is which should be the default? For me it's better to have
LANG=es_AR, just because I will have REAL string ordering in a query like this:

SELECT varfield FROM sometable ORDER BY varfield;

That would work great with 'C' locale if varfield didn't contain caracters like á,
é, í, ó, ú, ñ.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática    |     Administrador
               Universidad Nacional
                    del Litoral
-------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: Ericson Smith
Дата:
Сообщение: Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postmaster growing to consume all memory