Re: pg_dump bud with functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan <Ivan-Sun1(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump bud with functions
Date: 2005-10-27 14:34:36
Message-ID: 18862.1130423676@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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,

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2005-10-27 14:45:34 Re: BUG #2003: Bug with SQL UPDATE on a NUMERIC
Previous Message Ivan 2005-10-27 14:25:54 pg_dump bud with functions