Thread: Problems reverse engineering functions

Hi

Sorry if this has been raised before but the following function will not 
be reverse engineered correctly - The final default clause will be removed.

CREATE FUNCTION fn(a text, b integer DEFAULT NULL::integer, c integer 
DEFAULT NULL::integer) returns text as $$
BEGIN  return 't';
END;
$$ LANGUAGE 'plpgsql';


Many thanks

Kieran

Le 16/02/2010 18:57, Kieran McCusker a écrit :
> [...]
> Sorry if this has been raised before but the following function will not
> be reverse engineered correctly - The final default clause will be removed.
> 
> CREATE FUNCTION fn(a text, b integer DEFAULT NULL::integer, c integer
> DEFAULT NULL::integer) returns text as $$
> BEGIN
>   return 't';
> END;
> $$ LANGUAGE 'plpgsql';
> 

Thanks for your report. I worked on this tonight, I'll commit the fix in
a few minutes. The fix will be available in the next release.

Thanks again.

Regards.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com