Обсуждение: Procedure editing bug
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$
$BODY$
select 1, '2'::varchar
$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
$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;
$BODY$
select 1, '2'::varchar
$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;
I use pgAdmin 1.4.0 (Nov 5).
Best regards,
Alex Tyagloff
Alex Tyagloff
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