From: | Dave Barter <dave(at)phased(dot)co(dot)uk> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Bug report - Version 1.20.0 REL-1_20_0 |
Date: | 2015-02-25 12:58:40 |
Message-ID: | etPan.54edc700.41a7c4c9.1af@iMac.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Pgadmin cannot cope with default function parameters that are text arrays:-
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json,
prefix_param character varying DEFAULT 'attributes'::character varying,
column_prefixes character varying[] DEFAULT ARRAY['FA'::text,'FT'::text, 'F'::text, 'FTA'::text, 'FH'::text, 'WI'::text, 'WIT'::text, 'WIS'::text, 'WQ'::text, 'A'::text, 'FILTERS'::text]
) RETURNS json as
$$
BEGIN
END;
$$
LANGUAGE PLPGSQL
Displays as:-
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json DEFAULT 'attributes'::character varying,
prefix_param character varying DEFAULT ARRAY['FA'::text,
column_prefixes character varying[] DEFAULT 'FT'::text)
RETURNS json AS
$BODY$
BEGIN
END;
$BODY$
LANGUAGE plpgsql
--
Dave Barter
Web: http://www.phased.co.uk
Email:dave(at)phased(dot)co(dot)uk
Twitter:@Citizenfishy
From | Date | Subject | |
---|---|---|---|
Next Message | Leonard Boyce | 2015-02-25 15:15:32 | Re: Bug report - Version 1.20.0 REL-1_20_0 |
Previous Message | Sergey Shchukin | 2015-02-24 13:42:06 | Issue with a hanging apply process on the replica db after vacuum works on primary |