From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Paragon Corporation <lr(at)pcorp(dot)us> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug: Issue with Default Parameters |
Date: | 2011-12-04 13:27:29 |
Message-ID: | 1323005249.2311.36.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-12-04 14:36:25 | Re: Some functions with variadics don't show the right CREATE FUNCTION SQL |
Previous Message | Dave Page | 2011-12-03 07:50:05 | Re: Problems changing a view |