pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
regenereate data/ locales
2+ messages / 2 participants
[nested] [flat]

* regenereate data/ locales
@ 2005-08-22 14:10  Maxi Combina <maxicombina@gmail.com>
  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 15:09  Alvaro Herrera <alvherre@alvh.no-ip.org>
  parent: Maxi Combina <maxicombina@gmail.com>
  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