Extra empty lines PGv8.3.1

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Extra empty lines PGv8.3.1
Date: 2008-03-27 15:51:58
Message-ID: 02f701c89022$7e1a4dc0$1200a8c0@kharkov.localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

When I saw log file:
2008-03-27 16:42:47 EET COMMAND: CREATE or REPLACE FUNCTION "public"."test"(

OUT result varchar)

AS

$BODY$

DECLARE varTasksCount integer;

BEGIN

SELECT

count( at2.completion_code_ID )

but command actually was:
CREATE or REPLACE FUNCTION "public"."test"(
OUT result varchar)
AS
$BODY$
DECLARE varTasksCount integer;
BEGIN
SELECT
count( at2.completion_code_ID )

Without extra emply line.
Also it seem that
#pg_dumpall > dumpfile
#psql < dumpfile
have such problems.
all functions get extra empty lines in their bodies.
If I do next three times
#pg_dumpall > dumpfile
#psql < dumpfile
I get:
CREATE or REPLACE FUNCTION "public"."test"(

OUT result varchar)

AS

$BODY$

for function with body:
CREATE or REPLACE FUNCTION "public"."test"(
OUT result varchar)
AS
$BODY$

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2008-03-27 15:52:03 Re: BUG #4056: problem creating function with domain argument
Previous Message Tom Lane 2008-03-27 15:24:29 Re: Problem identifying constraints which should not be inherited