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

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 (view raw or flat)
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

pgsql-bugs by date

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

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