pg_dumpall: pg_conversion table not saved

Поиск
Список
Период
Сортировка
От Michael Enke
Тема pg_dumpall: pg_conversion table not saved
Дата
Msg-id 4821B58A.7030404@wincor-nixdorf.com
обсуждение исходный текст
Ответы Re: pg_dumpall: pg_conversion table not saved
Список pgsql-general
Hi list,
I updated pg_converion to set the condefault=false where I need it.
pg_dumpall does NOT write that table out and therefore it is not possible to restore, this update get lost.
Anybody know if this is an error or has an explanation why it has to work this way?

Background:
I have created my own conversion with CREATE DEFAULT CONVERSION ...
http://www.postgresql.org/docs/8.3/interactive/sql-createconversion.html
 > There should be only one default encoding in a schema for the encoding pair

Why can not the "CREATE DEFAULT CONVERSION ..."
      a) return with an error if there is another default conversion existing or
      b) silently set any other default to false
for the confor- and conto-encoding involved?

Regards,
Michael

--
Wincor Nixdorf International GmbH
Sitz der Gesellschaft: Paderborn
Registergericht Paderborn HRB 3507
Gesch�ftsf�hrer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. J�rgen Wunram
Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller
Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193

Diese E-Mail enth�lt vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt�mlich
erhaltenhaben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie
dieunbefugte Weitergabe dieser E-Mail ist nicht gestattet. 

This e-mail may contain confidential information. If you are not the intended recipient (or have received this e-mail
inerror) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distributionof the material in this e-mail is strictly forbidden. 


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Problems with memory
Следующее
От: "Pau Marc Munoz Torres"
Дата:
Сообщение: Problems with memory