| 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 |