Re: How to find correct locale name for CREATE DATABASE - Mailing list pgsql-general

From Alban Hertroys
Subject Re: How to find correct locale name for CREATE DATABASE
Date
Msg-id 500F33EF-755C-4C57-A286-538B2801B749@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: How to find correct locale name for CREATE DATABASE  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On 1 Dec 2010, at 21:46, Andrus wrote:

> Alban,
>
>> Seriously though, functionality like that has no place in a database server. That's the responsibility of the OS, or
ifit lacks in that respect, for third-party tools. 
>
> Thank you.
> So only portable way is to probe Postgres 9 locales using CREATE DATABASE command with expected locale names hoping
thatsome call suceeds? 


Well... if you really have to insist on using Postgres to determine system locales, I suppose you could do that - just
likeyou can use a crane to park your car. It's not a very sensible thing to attempt before looking at alternative
solutionsthough. 

I imagine there must be tools for that purpose, or otherwise some programming language will probably have functions for
thisthat you can use. Using the database server for this would be the last thing I'd try. 
I can't say I'm too well-versed in locale usage though, I usually just stick with English.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4cf6cd4e802658319426940!



pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Proper Permissions for /usr/local/pgsql/data
Next
From: Vick Khera
Date:
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19