Re: Procedure editing bug

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

In response to

Browse pgadmin-support by date

  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