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

pg_dump bud with functions

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

PostgreSQL 8.0.x, 8.1beta3, WinXP Pro SP2

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,
so when I open function definition in PGAdmin,
for example, I saw function text with extra empty lines:

CREATE OR REPLACE FUNCTION "foo"()
RETURNS bar AS
$$

  select * from "bar"

  where  bla-bla

  order by bla-bla;
  
$$
  LANGUAGE 'sql' VOLATILE;

It's very annoy, so please fix if it's not very hard.

Thank you!

-- 
Best regards,
 Ivan                          mailto:Ivan-Sun1(at)mail(dot)ru


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-10-27 14:34:36
Subject: Re: pg_dump bud with functions
Previous:From: Bruce MomjianDate: 2005-10-27 14:24:12
Subject: Re: BUG #2002: shows version wronly

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