pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedregenereate data/ locales
2+ messages / 2 participants
[nested] [flat]
* regenereate data/ locales
@ 2005-08-22 14:10 Maxi Combina <maxicombina@gmail.com>
2005-08-22 15:09 ` Re: regenereate data/ locales Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 2+ messages in thread
From: Maxi Combina @ 2005-08-22 14:10 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: regenereate data/ locales
2005-08-22 14:10 regenereate data/ locales Maxi Combina <maxicombina@gmail.com>
@ 2005-08-22 15:09 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2005-08-22 15:09 UTC (permalink / raw)
To: Maxi Combina <maxicombina@gmail.com>; +Cc: pgsql-admin
On Mon, Aug 22, 2005 at 11:10:54AM -0300, Maxi Combina wrote:
[must run initdb to switch locale]
>
> Is there any shorter way to change the locales? I didnot found any
> `recreate' or `regenerate' command.
No, initdb is the only option.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-22 15:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-22 14:10 regenereate data/ locales Maxi Combina <maxicombina@gmail.com>
2005-08-22 15:09 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox