regenereate data/ locales
| От | Maxi Combina |
|---|---|
| Тема | regenereate data/ locales |
| Дата | |
| Msg-id | 285af08705082207101029a56e@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: regenereate data/ locales
|
| Список | pgsql-admin |
Hello,
I am using postgresql 7.4.5, and was having some trouble with the
initcap() function. The problem was the following:
initcap('aéeou') = AéEou,
and I need
initcap('aéeou') = Aéeou,
I found in the documentation that to correct this behaviour, I must
run initdb --locale=SOMETHING.
Well, I did it (with --locale=es_AR), and now it works!
However, I could not did it in an easy way, because initdb complained
saying that the data/ directory was not empty. So, I had to dump all
my databases, remove the files from data/, run `initdb --locale=es_AR'
and restore the databases.
Is there any shorter way to change the locales? I didnot found any
`recreate' or `regenerate' command.
Regards,
Maxi
В списке pgsql-admin по дате отправления: