Thread: [pgAdmin III] #79: default value in function parameters are not shown

#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

#79: default value in function parameters are not shown
-------------------------------+--------------------------------------------
  Reporter:  Denis Feklushkin  |       Owner:  gleu     
      Type:  bug               |      Status:  closed   
  Priority:  minor             |   Milestone:  1.10.1   
 Component:  pgadmin           |     Version:  1.10     
Resolution:  fixed             |    Keywords:  functions
  Platform:                    |  
-------------------------------+--------------------------------------------
Changes (by gleu):

  * status:  new => closed
  * resolution:  => fixed
  * milestone:  => 1.10.1


Comment:

 Fixed in r8042 and r8043.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/79#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#79: default value in function parameters are not shown
-------------------------------+--------------------------------------------
  Reporter:  Denis Feklushkin  |       Owner:  gleu     
      Type:  bug               |      Status:  closed   
  Priority:  minor             |   Milestone:  1.10.1   
 Component:  pgadmin           |     Version:  1.10     
Resolution:  fixed             |    Keywords:  functions
  Platform:                    |  
-------------------------------+--------------------------------------------

Comment(by gleu):

 To comment a bit on this, default values for INOUT parameters were not
 handled. So I fixed this in 1.10 and trunk.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/79#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III