Re: pg_dump bud with functions - Mailing list pgsql-bugs

From Ivan
Subject Re: pg_dump bud with functions
Date
Msg-id 619821569.20051027184554@mail.ru
Whole thread Raw
In response to Re: pg_dump bud with functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello,

Thursday, October 27, 2005, 6:34:36 PM, you wrote:

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?

Yes, it does. :)
Thank you very much!


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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #2003: Bug with SQL UPDATE on a NUMERIC
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #2001: Signal 11 after concurrent inserts + updates