[pgAdmin III] #79: default value in function parameters are not shown
От | pgAdmin Trac |
---|---|
Тема | [pgAdmin III] #79: default value in function parameters are not shown |
Дата | |
Msg-id | 057.46a45dabf88ff584df216a744ae012c9@code.pgadmin.org обсуждение исходный текст |
Ответы |
Re: [pgAdmin III] #79: default value in function parameters are not
shown
Re: [pgAdmin III] #79: default value in function parameters are not shown |
Список | pgadmin-hackers |
#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
В списке pgadmin-hackers по дате отправления: