Bug: Default parameters in functions not being maintained in pgAdmin definition - Mailing list pgadmin-support

From Paragon Corporation
Subject Bug: Default parameters in functions not being maintained in pgAdmin definition
Date
Msg-id F7C00D861964424C9D5314825E2B499B@O
Whole thread Raw
Responses Re: Bug: Default parameters in functions not being maintained in pgAdmin definition  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
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.

Thanks,
Regina





pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Error during make from git on Opensuse 12.2
Next
From: Efe Erdoğru
Date:
Subject: Double click to edit column