Does initdb -e is working ? (Latest dev. snapshot)

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Does initdb -e is working ? (Latest dev. snapshot)
Дата
Msg-id Pine.GSO.3.96.SK.1000129130635.18405q-100000@ra
обсуждение исходный текст
Ответы Re: [HACKERS] Does initdb -e is working ? (Latest dev. snapshot)  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Re: [HACKERS] Does initdb -e is working ? (Latest dev. snapshot)  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Probably I miss something 
I tried latest snapshot and notice some changes in configure.
Everything went smoothly on my Linux 2.2.14, glic 2.1.2 system.

One problem: I tried initdb -e koi8 and it doesn't works - 
all databases I have are in SQL_ASCII encodingDatabase  |  Owner   | Encoding  
-----------+----------+-----------discovery | postgres | SQL_ASCIItemplate1 | postgres | SQL_ASCIItest      | postgres
|SQL_ASCII
 

createdb -E koi8 works as expected:
createdb -E koi8 aa
CREATE DATABASE
zen:~$ psql -l       List of databasesDatabase  |  Owner   | Encoding  
-----------+----------+-----------aa        | postgres | KOI8discovery | postgres | SQL_ASCIItemplate1 | postgres |
SQL_ASCIItest     | postgres | SQL_ASCII
 

I found -e for initdb , -E for createdb options for specifying encoding a 
little bit confused - why not just use one of them !

Is't possible to change encoding of database except dump/destroydb/createdb
cycle ? Is't worth to have pg_encoding to do this ?

Regards,
Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: [HACKERS] Copyright
Следующее
От: Peter Eisentraut
Дата:
Сообщение: GUC (Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates)