From: | Leonard Boyce <leonard(dot)boyce(at)lucidlayer(dot)com> |
---|---|
To: | Dave Barter <dave(at)phased(dot)co(dot)uk> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Bug report - Version 1.20.0 REL-1_20_0 |
Date: | 2015-02-25 15:15:32 |
Message-ID: | CAKj1m=+3aOCTe5cRcVeC1mmQZBTyQBj_Kqx4n_Q4NfufR-4JvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi Dave,
Definitely looks like a bug. Using the '{}'::character varying[]
format for the array seems to work fine though.
Example;
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json,
prefix_param character varying DEFAULT 'attributes'::character varying,
column_prefixes character varying[] DEFAULT
'{FA,FT,F,FTA,FH,WI,WIT,WIS,WQ,A,FILTERS}'::character varying[]
) RETURNS json as
$$
BEGIN
END;
$$
LANGUAGE PLPGSQL
On Wed, Feb 25, 2015 at 7:58 AM, Dave Barter <dave(at)phased(dot)co(dot)uk> wrote:
> 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 | Sergey Shchukin | 2015-02-26 06:25:31 | Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary |
Previous Message | Dave Barter | 2015-02-25 12:58:40 | Bug report - Version 1.20.0 REL-1_20_0 |