| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-27 14:34:36 | Re: pg_dump bud with functions |
| Previous Message | Bruce Momjian | 2005-10-27 14:24:12 | Re: BUG #2002: shows version wronly |