From: | Maximilian Tyrtania <lists(at)contactking(dot)de> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: default parameters |
Date: | 2012-07-18 14:22:24 |
Message-ID: | B26C6FA3-1624-405A-A20A-B0380EE197CD@contactking.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2012-07-18 15:14:13 | schema diff |
Previous Message | Michal Kozusznik | 2012-07-18 06:24:18 | Re: Search the schema |