Thread: Bug: Issue with Default Parameters

Bug: Issue with Default Parameters

From
"Paragon Corporation"
Date:
I noticed another issue with default parameters which I didn't see listed.
I see it in 1.14 at any rate not sure it is an issue in lower versions.
That is if I write a function like this:CREATE OR REPLACE FUNCTION test_defaults(test text DEFAULT '')    RETURNS text
AS
$$   SELECT 'hello'::text;

$$
LANGUAGE 'sql';


And then use the variable dialog to defined variables for it -- say
search_path.

--it generates the invalid statement
ALTER FUNCTION public.test_defaults(text DEFAULT ''::text) SET
search_path=public;

Instead of 
ALTER FUNCTION public.test_defaults(text) SET search_path=public;

Thanks,
Regina




Re: Bug: Issue with Default Parameters

From
Guillaume Lelarge
Date:
On Tue, 2011-11-22 at 20:19 -0500, Paragon Corporation wrote:
> I noticed another issue with default parameters which I didn't see listed.
> I see it in 1.14 at any rate not sure it is an issue in lower versions.
>  
> That is if I write a function like this:
>  CREATE OR REPLACE FUNCTION test_defaults(test text DEFAULT '') 
>     RETURNS text AS
> $$
>     SELECT 'hello'::text;
> 
> $$
> LANGUAGE 'sql';
> 
> 
> And then use the variable dialog to defined variables for it -- say
> search_path.
> 
> --it generates the invalid statement
> ALTER FUNCTION public.test_defaults(text DEFAULT ''::text) SET
> search_path=public;
> 
> Instead of 
> ALTER FUNCTION public.test_defaults(text) SET search_path=public;
> 

You're right. This bug is now fixed. Unfortunately, it won't make it for
1.14.1, as it's already compiled and packaged. Will be available with
1.14.2 though.

Thanks for your report, and sorry for the delay.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com