PostgreSQL Database cluster with multiple different locale settings?

Started by Mario Weilguniabout 21 years ago4 messagesgeneral

mweilguni@sime.com

about 21 years ago

Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? I
checked a lot, and currently I found only the initdb way to influence
--lc-ctype and --lc-collate

Thanks!
Mario

Peter Eisentraut

peter_e@gmx.net

about 21 years ago

In reply to: Mario Weilguni (#1)

Re: PostgreSQL Database cluster with multiple different locale settings?

Mario Weilguni wrote:

Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?

No, sorry.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

mweilguni@sime.com

about 21 years ago

In reply to: Peter Eisentraut (#2)

Re: PostgreSQL Database cluster with multiple different locale settings?

Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut:

Mario Weilguni wrote:

Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?

No, sorry.

Thanks for the reply. Does that mean it's simply impossible, or nobody has
ever need such a beast?

IMO it should be possible apply different locale settings after forking the
backend, or am I wrong here?

bruce@momjian.us

almost 21 years ago

In reply to: Mario Weilguni (#3)

Re: PostgreSQL Database cluster with multiple different locale

Mario Weilguni wrote:

Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut:

Mario Weilguni wrote:

Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?

No, sorry.

Thanks for the reply. Does that mean it's simply impossible, or nobody has
ever need such a beast?

IMO it should be possible apply different locale settings after forking the
backend, or am I wrong here?

Some people have asked for it, but because we have some global tables
like pg_shadow and pg_database, it is hard to change per database.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073