On Fri, 2012-09-07 at 11:02 -0400, Paragon Corporation wrote: > I'm using 1.16 beta 4 on Windows (the version that comes with EDB PostgreSQL > 9.2RC1) > > When I do this: > > CREATE OR REPLACE FUNCTION test_defaults(param_int integer, param_def text > DEFAULT NULL::text) > RETURNS text AS > $$ > SELECT $2; > $$ > language sql; > > > Then right click or look in code paid to see the function created, it shows > this: > > CREATE OR REPLACE FUNCTION public.test_defaults(param_int integer, param_def > text) > RETURNS text AS > $BODY$ > SELECT $2; > $BODY$ > LANGUAGE sql VOLATILE > COST 100; > > > As a result I can' reuse it becauseit says default parameters can't be > changed. >
Works for me on 1.16.0. Can you try on the final release, please? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
