#79: default value in function parameters are not shown
------------------------------+---------------------------------------------
Reporter: Denis Feklushkin | Owner: gleu
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: functions | Platform:
------------------------------+---------------------------------------------
In a function argument with a default value this value are not shown in
pgadmin3
When you try to change this function you get an error as when trying to
change the function arguments
An example of such a function:
CREATE OR REPLACE FUNCTION public.demo(INOUT level integer DEFAULT 0)
RETURNS integer
LANGUAGE plpgsql
STABLE STRICT
AS $function$
BEGIN
return;
END;
$function$
This function as viewed in pgadmin3:
-- Function: demo(integer)
-- DROP FUNCTION demo(integer);
CREATE OR REPLACE FUNCTION demo(INOUT "level" integer)
RETURNS integer AS
$BODY$
BEGIN
return;
END;
$BODY$
LANGUAGE 'plpgsql' STABLE STRICT
COST 100;
ALTER FUNCTION demo(integer) OWNER TO xxx;
(from the debian bug #547940)
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/79>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III