On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: > 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
It works in 1.16 beta 2. And there shouldn't be any more release of 1.14. So I advise you to update to 1.16 beta. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
