Re: [pgadmin-support] Bug report - Version 1.20.0 REL-1_20_0

2015-02-25 Thread Leonard Boyce
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 ch

[pgadmin-support] Bug report - Version 1.20.0 REL-1_20_0

2015-02-25 Thread Dave Barter
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,'