Re: default parameters

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

Maximilian Tyrtania
http://www.contactking.de