Skip site navigation (1) Skip section navigation (2)

Re: pg_dump bud with functions

From: Ivan <Ivan-Sun1(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump bud with functions
Date: 2005-10-27 14:45:54
Message-ID: 619821569.20051027184554@mail.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,

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

TL> Ivan <Ivan-Sun1(at)mail(dot)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(at)mail(dot)ru


In response to

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-10-27 16:38:54
Subject: Re: BUG #2001: Signal 11 after concurrent inserts + updates
Previous:From: Stephan SzaboDate: 2005-10-27 14:45:34
Subject: Re: BUG #2003: Bug with SQL UPDATE on a NUMERIC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group