Bug report - Version 1.20.0 REL-1_20_0
От | Dave Barter |
---|---|
Тема | Bug report - Version 1.20.0 REL-1_20_0 |
Дата | |
Msg-id | etPan.54edc700.41a7c4c9.1af@iMac.local обсуждение исходный текст |
Ответы |
Re: Bug report - Version 1.20.0 REL-1_20_0
(Leonard Boyce <leonard.boyce@lucidlayer.com>)
|
Список | pgadmin-support |
<div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height:auto;">Pgadmin cannot cope with default function parameters that are text arrays:-</div><div id="bloop_customfont"style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height:auto;"><br /></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0);margin: 0px; line-height: auto;"><br /></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><div id="bloop_customfont"style="margin: 0px;">CREATE OR REPLACE FUNCTION ng_research.test(</div><div id="bloop_customfont" style="margin:0px;"> filter_param json, </div><div id="bloop_customfont" style="margin: 0px;"><span class="Apple-tab-span"style="white-space:pre"> </span>prefix_param character varying DEFAULT 'attributes'::character varying, </div><divid="bloop_customfont" style="margin: 0px;"><span class="Apple-tab-span" style="white-space:pre"> </span>column_prefixescharacter 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]</div><div id="bloop_customfont" style="margin:0px;"><span class="Apple-tab-span" style="white-space:pre"> </span>) RETURNS json as </div><div id="bloop_customfont"style="margin: 0px;">$$</div><div id="bloop_customfont" style="margin: 0px;">BEGIN</div><div id="bloop_customfont"style="margin: 0px;"><br /></div><div id="bloop_customfont" style="margin: 0px;">END;</div><div id="bloop_customfont"style="margin: 0px;">$$</div><div id="bloop_customfont" style="margin: 0px;">LANGUAGE PLPGSQL</div><divid="bloop_customfont" style="margin: 0px;"><br /></div><div id="bloop_customfont" style="margin: 0px;">Displaysas:-</div><div id="bloop_customfont" style="margin: 0px;"><br /></div><div id="bloop_customfont" style="margin:0px;"><div id="bloop_customfont" style="margin: 0px;">CREATE OR REPLACE FUNCTION ng_research.test(</div><divid="bloop_customfont" style="margin: 0px;"> filter_param json DEFAULT 'attributes'::charactervarying,</div><div id="bloop_customfont" style="margin: 0px;"> prefix_param character varying DEFAULTARRAY['FA'::text,</div><div id="bloop_customfont" style="margin: 0px;"> column_prefixes character varying[] DEFAULT'FT'::text)</div><div id="bloop_customfont" style="margin: 0px;"> RETURNS json AS</div><div id="bloop_customfont"style="margin: 0px;">$BODY$</div><div id="bloop_customfont" style="margin: 0px;">BEGIN</div><div id="bloop_customfont"style="margin: 0px;"><br /></div><div id="bloop_customfont" style="margin: 0px;">END;</div><div id="bloop_customfont"style="margin: 0px;">$BODY$</div><div id="bloop_customfont" style="margin: 0px;"> LANGUAGE plpgsql</div></div></div><br/><div class="bloop_sign" id="bloop_sign_1424868949432649984"><div style="font-family:helvetica,arial;font-size:13px"><spanstyle="font-size: small; text-align: -webkit-auto; line-height: normal;orphans: 2; widows: 2; font-family: arial;">-- </span><br style="font-size: small; text-align: -webkit-auto; line-height:normal; orphans: 2; widows: 2; font-family: arial;" /><span style="font-size: small; text-align: -webkit-auto;line-height: normal; orphans: 2; widows: 2; font-family: arial;">Dave Barter</span><br style="font-size: small;text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;" /><br style="font-size:small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;" /><spanstyle="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Web: </span><ahref="http://www.phased.co.uk/" style="font-size: small; text-align: -webkit-auto; line-height: normal;orphans: 2; widows: 2; font-family: arial;" target="_blank">http://www.phased.co.uk</a><br style="font-size: small;text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;" /><a href="mailto:Email%3Adave@phased.co.uk"style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2;widows: 2; font-family: arial;" target="_blank">Email:dave@phased.co.uk</a><br style="font-size: small; text-align: -webkit-auto;line-height: normal; orphans: 2; widows: 2; font-family: arial;" /><span style="font-size: small; text-align:-webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Twitter:@Citizenfishy</span></div></div>
В списке pgadmin-support по дате отправления:
Предыдущее
От: Sergey ShchukinДата:
Сообщение: Issue with a hanging apply process on the replica db after vacuum works on primary