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 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,'