From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Exgen <ex-gen(at)yandex(dot)ru> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Procedure editing bug |
Date: | 2005-11-09 10:27:47 |
Message-ID: | 4371CF23.2080500@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-11-09 11:35:56 | Re: [1.4rc1] Can't change column type |
Previous Message | Tom.Zschockelt | 2005-11-09 10:18:48 | group role membership |