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$

Reply via email to