Re: pg_dump bud with functions

Поиск
Список
Период
Сортировка
От Ivan
Тема Re: pg_dump bud with functions
Дата
Msg-id 927759848.20051031122409@mail.ru
обсуждение исходный текст
Ответ на Re: pg_dump bud with functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hello,

TL> Ivan <Ivan-Sun1@mail.ru> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).

>> If I create plain backup using pg_dump
>> it generates functions with
>> 0D 0D 0A on the end of the body lines,

TL> Good ol' Windows :-(.  Try writing the dump file with "pg_dump -f file"
TL> instead of "pg_dump >file" ... does that make it better?

This problem is actual for pg_dumpall because there is no -f file
option for it - output is always written to standard output.
Is it possible to add this option to pg_dumpall too?

Thank you for support!


--
Best regards,
 Ivan                            mailto:Ivan-Sun1@mail.ru

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

Предыдущее
От: tomas@tuxteam.de (Tomas Zerolo)
Дата:
Сообщение: Re: importing from 8.0.3 unicode problem
Следующее
От: "Roddi Walker"
Дата:
Сообщение: BUG #2010: COPY command does not recognise UTF-8 text files with leading BOM