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

From Tom Lane
Subject Re: pg_dump bud with functions
Date
Msg-id 18862.1130423676@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump bud with functions  (Ivan <Ivan-Sun1@mail.ru>)
Responses Re: pg_dump bud with functions
Re: pg_dump bud with functions
List pgsql-bugs
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,

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

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #2002: shows version wronly
Next
From: Stephan Szabo
Date:
Subject: Re: BUG #2003: Bug with SQL UPDATE on a NUMERIC