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$
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 |