When I saw log file:
2008-03-27 16:42:47 EET COMMAND: CREATE or REPLACE FUNCTION "public"."test=
"(
OUT result varchar)
AS=20
$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=20
$BODY$
DECLARE varTasksCount integer;
BEGIN
SELECT
count( at2.completion_code_ID )
Without extra emply line.
Also it seem that=20
#pg_dumpall > dumpfile=20
#psql < dumpfile=20
have such problems.
all functions get extra empty lines in their bodies.
If I do next three times
#pg_dumpall > dumpfile=20
#psql < dumpfile=20
I get:
CREATE or REPLACE FUNCTION "public"."test"(
OUT result varchar)
AS=20
$BODY$
for function with body:
CREATE or REPLACE FUNCTION "public"."test"(=20
OUT result varchar)
AS=20
$BODY$