Default Values of Function Arguments are garbled if they contain a comma
От | Frank Limpert |
---|---|
Тема | Default Values of Function Arguments are garbled if they contain a comma |
Дата | |
Msg-id | 1096511243.4605225.1457448081689.JavaMail.yahoo@mail.yahoo.com обсуждение исходный текст |
Список | pgadmin-support |
<div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande,sans-serif;font-size:8px"><div id="yui_3_16_0_1_1457446851819_4122">Hello pgAdmin III list,</div><div id="yui_3_16_0_1_1457446851819_4123"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4124">Recently, I found thatDefault Values of Function Arguments are garbled if they contain unquoted commas. This happens in the Function PropertyDialog as well as using the CREATE script menu item.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4198"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4233">1. Example, where Defaultis garbled:</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4337">----</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4336">CREATEOR REPLACE FUNCTION blah(foo integer[] DEFAULT ARRAY[1, 2, 3])</div><div dir="ltr"id="yui_3_16_0_1_1457446851819_4307"> RETURNS integer AS</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4234">$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE;<br />----</div><div dir="ltr"id="yui_3_16_0_1_1457446851819_4229">#### CREATE script menu item produces:</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4265">CREATEOR REPLACE FUNCTION blah(foo integer[] DEFAULT ARRAY[1)<br /> RETURNS integerAS<br />$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE<br /> COST 100;</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4407"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4357">2. Example, where Defaultis left intact:</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4356">----</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4352">CREATEOR REPLACE FUNCTION blub(bar integer[] DEFAULT '{1,2,3}'::integer[])<br /> RETURNSinteger AS</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4383"> $BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGEsql STABLE;<br />----</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4229">#### CREATE script menu item produces:</div><divdir="ltr" id="yui_3_16_0_1_1457446851819_4426">CREATE OR REPLACE FUNCTION blub(bar integer[] DEFAULT '{1,2,3}'::integer[])<br/> RETURNS integer AS<br />$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE<br /> COST100;</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4481"><br /></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4480">3.Fortunately, the psql command \sf works correctly and reproduces these functions asshown above in the first place.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4479"><br /></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4478">Idid my test with the Windows Program pgAdmin Version 1.22.0 (Jan 8 2016, rev:REL-1_22_0)under Windows 7 64bit.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4578"><br /></div><div dir="ltr"id="yui_3_16_0_1_1457446851819_4577">Please fix this bug.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4673"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4674">Happy computing...</div><divdir="ltr" id="yui_3_16_0_1_1457446851819_4675">Frank<br /></div></div>
В списке pgadmin-support по дате отправления: