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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
