Bug: Default parameters in functions not being maintained in pgAdmin definition

From: "Paragon Corporation" <lr(at)pcorp(dot)us>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Bug: Default parameters in functions not being maintained in pgAdmin definition
Date: 2012-09-07 15:02:07
Message-ID: F7C00D861964424C9D5314825E2B499B@O
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Efe Erdoğru 2012-09-08 15:02:27 Double click to edit column
Previous Message Dave Page 2012-09-06 10:44:04 Re: Error during make from git on Opensuse 12.2