Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-02 Thread Robert Gravsjö
On 2010-12-01 09.26, Andrus wrote: Thom, You can list available locales on your system with: locale -a Thank you. How to resolve this issue if only 5432 port is open in server ? Maybe asking the sysadmin of that host to return the result of "locale -a"? Btw, are you sure et_EE.UTF-8 is

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Craig Ringer
On 12/02/2010 02:49 AM, Alban Hertroys wrote: Because, as opposed to the developers of the projects that you're apparently familiar with, the Postgres developers have common sense ;) Seriously though, functionality like that has no place in a database server. That's the responsibility of the

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Alban Hertroys
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 if it lacks in that respect, for >> third-party tools. > > Thank you. > So only portable way is to probe Postgres 9 local

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Andrus
Alban, Seriously though, functionality like that has no place in a database server. That's the responsibility of the OS, or if it 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 na

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Alban Hertroys
On 1 Dec 2010, at 15:15, Andrus wrote: >> There is no portable operating system interface to get the names of all >> locales. > > Thank you. > Why postgres does not use conditional directives like > > #ifdef WINDOWS > ... > #endif > > #ifdef LINUX > .. > #endif > > to return list of available

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Andrus
There is no portable operating system interface to get the names of all locales. Thank you. Why postgres does not use conditional directives like #ifdef WINDOWS ... #endif #ifdef LINUX .. #endif to return list of available locales ? Andrus. -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Peter Eisentraut
On ons, 2010-12-01 at 10:26 +0200, Andrus wrote: > How to get list of available locale names from Postgres ? > Why Postgres does not have command which returns available locale > names ? > How to use same locale names in every platform? There is no portable operating system interface to get the n

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Raymond O'Donnell
On 01/12/2010 08:26, Andrus wrote: Thom, You can list available locales on your system with: locale -a Thank you. How to resolve this issue if only 5432 port is open in server ? Based on my limited knowledge, postgres does not have command to run "locale -a" How to get list of available loca

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-12-01 Thread Andrus
Thom, You can list available locales on your system with: locale -a Thank you. How to resolve this issue if only 5432 port is open in server ? Based on my limited knowledge, postgres does not have command to run "locale -a" How to get list of available locale names from Postgres ? Why Postg

Re: [GENERAL] How to find correct locale name for CREATE DATABASE

2010-11-30 Thread Thom Brown
2010/11/30 Andrus : > I tried in  Debian ("PostgreSQL 9.0.1 on x86_64-pc-linux-gnu, compiled by > GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit") : > > 1. CREATE DATABASE "mydb" WITH TEMPLATE=template0 > LC_COLLATE='Estonian_Estonia.1257' LC_CTYPE='Estonian_Estonia.1257' > OWNER="mydb_owner" ENCO