[pgadmin-support] default parameters

[Andrey Vinogradov]

Hi,

There is a function with the default parameter:

CREATE OR REPLACE FUNCTION test(p_int integer *default 1*)
  RETURNS void AS
$BODY$declare
begin
--foo;
end;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;


The object browser of the pgAdmin III has been refreshed more than once.
The SQL query of the test fuction is

CREATE OR REPLACE FUNCTION test(p_int integer) -- <=== default value is
disappear
  RETURNS void AS
$BODY$declare
begin
--foo;
end;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

pgAdmin III Version 1.14.3 (Jun 1 2012, rev:REL-1_14_3)
postgresql-9.1.4-1-windows-x64
Windows 7
-- 

Thanks and best wishes,
Andrei Vinogradov

email:  octo...@gmail.com