Re: default parameters

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