<html><head></head><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:16px"><div id="yiv0191261518"><div id="yui_3_16_0_1_1457634192700_2662"><div id="yui_3_16_0_1_1457634192700_2661" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:16px;"><div id="yiv0191261518yui_3_16_0_1_1457632008911_2573">Hi everybody, it's my first question ever on this list.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2626"><div id="yui_3_16_0_1_1457634192700_4159" dir="ltr"><a id="yui_3_16_0_1_1457634192700_4158" class="reference external" href="mailto:mapserver-users%40lists.osgeo.org"><br></a></div></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2592">Some facts before<br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2627"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2609">I'm running Mapserver 6.2.1 (old vm machine)</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2618">Postgres 9.3.6 with postgis 2.1.7</div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_3240">Postgres is listening all IP and accept all incoming IP. pg_hba.conf an postgresql.conf<br></div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_2666">Publishing succesfully multiple layers base on Postgis and everything seem to be ok.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2693"><br></div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_2710"><div id="yui_3_16_0_1_1457634192700_3329" dir="ltr">I try to make a template presenting ONE-TO-MANY content from PG to PG.(http://mapserver.org/mapfile/join.html)</div></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2767" dir="ltr">My ONE part is my geometry and is published in WMS</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3297" dir="ltr">My MANY is an associated table. <br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3306" dir="ltr"><div id="yui_3_16_0_1_1457634192700_2739">My key between my 2 tables is a unique string (21) named geocode</div><div id="yui_3_16_0_1_1457634192700_2758">Both have PK. <br></div></div><div id="yui_3_16_0_1_1457634192700_2773" dir="ltr"><br></div><div id="yui_3_16_0_1_1457634192700_2660" dir="ltr"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2876" dir="ltr">Here my problem.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3317" dir="ltr"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2877" dir="ltr">On getfeatureinfo, it is suppose to return a html mime type for my template. Header, central (MANY) and FOOTER.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2878" dir="ltr">When I call the same dataset in DBF, the getfeatureinfo is returned properly.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2879" dir="ltr">When I call the same dataset in postgres, the getfeatureinfo is NOT returned properly.</div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3387" dir="ltr">I think that my connection is well done by connection string because if I change table or column name to a not existing one, MapServer raise an error.<br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3388" dir="ltr"><span id="yiv0191261518yui_3_16_0_1_1457632008911_3378" class="yiv0191261518Apple-style-span" style="border-collapse:separate;color:rgb(0, 0, 0);font-family:'Times New Roman';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;font-size:medium;"><br></span></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3003" dir="ltr"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2913" dir="ltr">This example don't work properly. <br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2685"><br></div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_2691">TEMPLATE "oneToMany.html"<br>HEADER "oneToMany_header.html"<br>FOOTER "oneToMany_footer.html" <br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2921" dir="ltr"><br></div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_2676">JOIN<br> NAME 'ieqm'<br> CONNECTIONTYPE postgresql<br> CONNECTION "host=XX.XX.XX.XX port=XXXX user=PG password=PGPWD dbname=BDX"<br> TABLE 'table_150513" <br> FROM 'geocode'<br> TO 'geocode'<br> TYPE ONE-TO-MANY<br> TEMPLATE 'oneToMany_join.html'<br> END<br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2674"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3148"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_3147"><br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2913" dir="ltr">This example work properly.<br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2685"><br></div><div dir="ltr" id="yiv0191261518yui_3_16_0_1_1457632008911_2691">TEMPLATE "oneToMany.html"<br>HEADER "oneToMany_header.html"<br>FOOTER "oneToMany_footer.html" <br></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2921" dir="ltr"><br></div>JOIN<br> NAME 'ieqm'<br> TABLE "table_150513.dbf" <br> FROM 'geocode'<br> TO 'geocode'<br> TYPE ONE-TO-MANY<br> TEMPLATE 'oneToMany_join.html'<br><div id="yiv0191261518yui_3_16_0_1_1457632008911_3145" dir="ltr"><div id="yui_3_16_0_1_1457634192700_3603"> END</div><div id="yui_3_16_0_1_1457634192700_3429"><br></div><div id="yui_3_16_0_1_1457634192700_3430"><br></div><div id="yui_3_16_0_1_1457634192700_3431">Thanks!</div><div id="yui_3_16_0_1_1457634192700_3432"><br></div><span id="yui_3_16_0_1_1457634192700_3641" style="font-size: 14pt; font-family: "Arial","sans-serif";"></span></div><div id="yiv0191261518yui_3_16_0_1_1457632008911_2606">
<div id="yui_3_16_0_1_1457634192700_3662" class="x_MsoNormal"><span id="yui_3_16_0_1_1457634192700_3660" style="font-size: 12pt; font-family: "Arial","sans-serif";">Pierre-Étienne Lord</span></div><div id="yui_3_16_0_1_1457634192700_3986" class="x_MsoNormal"><span id="yui_3_16_0_1_1457634192700_3660" style="font-size: 12pt; font-family: "Arial","sans-serif";"><br></span></div><span id="yui_3_16_0_1_1457634192700_3646" style="font-size: 12pt; font-family: "Arial","sans-serif";"><a id="yui_3_16_0_1_1457634192700_3645" href="https://outlook.mrnf.gouv.qc.ca/owa/redir.aspx?SURL=YaZ5UYf2IPMJv7ADsBDnNhbct83j8H_NQZOvg_R1SvvMdStAFEnTCG0AYQBpAGwAdABvADoAcABpAGUAcgByAGUALQBlAHQAaQBlAG4AbgBlAC4AbABvAHIAZABAAG0AZgBmAHAALgBnAG8AdQB2AC4AcQBjAC4AYwBhAA..&URL=mailto%3apierre-etienne.lord%40mffp.gouv.qc.ca"><span id="yui_3_16_0_1_1457634192700_3644"></span></a></span></div></div></div></div></div></body></html>