From: | Kozusznik Michal <kozusznik(dot)michal(at)ifortuna(dot)cz> |
---|---|
To: | Andrey Vinogradov <octonog(at)gmail(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: default parameters |
Date: | 2012-07-03 07:05:24 |
Message-ID: | 55C09112-8CB8-497C-A604-18713E49A8F2@ifortuna.cz |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I repored this bug already. try 1.14.2
MK
2. 7. 2012 v 13:09, "Andrey Vinogradov" <octonog(at)gmail(dot)com<mailto:octonog(at)gmail(dot)com>>:
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
--
Thanks and best wishes,
Andrei Vinogradov
email: octonog(at)gmail(dot)com<mailto:octonog(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Rohan Carly | 2012-07-03 07:38:11 | 'create script' not usable for columns set 'not null' and 'default' |
Previous Message | Rohan Carly | 2012-07-03 06:50:50 | Re: saved passwords deleted |