Re: default parameters

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:  octonog@gmail.com