On Wed, 2012-07-18 at 16:22 +0200, Maximilian Tyrtania wrote: > Am 02.07.2012 um 22:46 schrieb Guillaume Lelarge: > > > 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. > > I'm still seeing this issue in 1.16 beta 2. I'm on Mac OS 10.7.4, running PG > 9.0.3 >
Still works for me on PostgreSQL 9.0.8, and pgAdmin 1.16 and 1.17. Doesn't work on 1.14 but, as I said, there won't be any more release of 1.14. -- 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
