Re: Procedure editing bug - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Procedure editing bug
Date
Msg-id 4371CF23.2080500@pse-consulting.de
Whole thread Raw
In response to Procedure editing bug  ("Exgen" <ex-gen@yandex.ru>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: "Petri Jooste"
Date:
Subject: Re: pgadmin3 1.4.0 for Mandriva
Next
From: Andreas Pflug
Date:
Subject: Re: [1.4rc1] Can't change column type