Re: default parameters

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: Raw Message | Whole Thread | 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>

In response to

Browse pgadmin-support by date

  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