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@mail.ru
