Re: Some functions with variadics don't show the right CREATE FUNCTION SQL

On Mon, 2011-11-21 at 17:55 -0500, Paragon Corporation wrote:
> We discovered a recent issue on PostGIS dev which we think is a pgAdmin
> issue. We have reproduced on 1.14 and 1.10
>
> That is when we create a function like this:
>
> CREATE OR REPLACE FUNCTION test_regprocedure(
>
> func regprocedure,
>
> VARIADIC junk text[] DEFAULT NULL
>
> )
>
> RETURNS text AS $$
>
> BEGIN
>
> RETURN NULL;
>
> END;
>
> $$ LANGUAGE 'plpgsql';
>
> It shows this in the function window
>
> CREATE OR REPLACE FUNCTION public.test_regprocedure(IN func regprocedure
> DEFAULT NULL::text[], VARIADIC junk text[])
> RETURNS text AS
> $BODY$
> BEGIN
> RETURN NULL;
> END;
> $BODY$
> LANGUAGE plpgsql VOLATILE
> COST 100;
> ALTER FUNCTION public.test_regprocedure(regprocedure, text[])
> OWNER TO postgres;
>
>
> We have this as a ticketed item which we have closed on our end.
> Please refer to :
> http://trac.osgeo.org/postgis/ticket/1283
>
> If you need further details.
>

I reproduced the issue last weekend. I probably won't have time to work
on it before next weekend.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com