Bug report - Version 1.20.0 REL-1_20_0

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

Responses

Browse pgadmin-support by date

  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