Postgres Pro
Downloads
Home   >   mailing lists

Thread: Procedure editing bug

Procedure editing bug

From
"Exgen"
Date:
Hello,
 
When I open procedure properties dialog and open "SQL" tab, it contains corrupted procedure definition, i.e.
 
Instead of
 
CREATE OR REPLACE FUNCTION "testProc"(IN "in_Param1" "varchar", IN "in_Param2" int4, OUT "out_Param1" int4, OUT "out_Param2" "varchar") AS
$BODY$
    select 1, '2'::varchar
$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
 
I get
 
CREATE OR REPLACE FUNCTION "testProc"(IN" in_Param1" "varchar", IN" in_Param2" int4, OUT" out_Param1" int4, OUT" out_Param2" "varchar") AS
$BODY$
    select 1, '2'::varchar
$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
 
I use pgAdmin 1.4.0 (Nov 5).
 
Best regards,
Alex Tyagloff

Re: Procedure editing bug

From
Andreas Pflug
Date:
Exgen wrote:
> Hello,
>  
> When I open procedure properties dialog and open "SQL" tab, it contains 
> corrupted procedure definition, i.e.
>  
> Instead of
>  
> CREATE OR REPLACE FUNCTION "testProc"(IN "in_Param1" "varchar", IN 
> "in_Param2" int4, OUT "out_Param1" int4, OUT "out_Param2" "varchar") AS
> $BODY$
>     select 1, '2'::varchar
> $BODY$
> LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
>  
> I get
>  
> CREATE OR REPLACE FUNCTION "testProc"(IN" in_Param1" "varchar", IN" 
> in_Param2" int4, OUT" out_Param1" int4, OUT" out_Param2" "varchar") AS
> $BODY$
>     select 1, '2'::varchar
> $BODY$
> LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
>  
> I use pgAdmin 1.4.0 (Nov 5).

Fixed in svn for 1.4.1 and HEAD, thanks for reporting.

Regards,
Andreas