<p dir="ltr">Hi, </p>
<p dir="ltr">If you use views in PostgreSQL to join the tables, you may not need go use the Join in mapfile. </p>
<div class="gmail_quote">Em 10/03/2016 18:48, "Pierre-Étienne Lord" <<a href="mailto:pe_lord@yahoo.ca">pe_lord@yahoo.ca</a>> escreveu:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:times new roman,new york,times,serif;font-size:16px"><div><div><div style="color:#000;background-color:#fff;font-family:times new roman,new york,times,serif;font-size:16px"><div>Hi everybody, it's my first question ever on this list.</div><div><div dir="ltr"><a href="mailto:mapserver-users%40lists.osgeo.org" target="_blank"><br></a></div></div><div>Some facts before<br></div><div><br></div><div>I'm running Mapserver 6.2.1 (old vm machine)</div><div>Postgres 9.3.6 with postgis 2.1.7</div><div dir="ltr">Postgres is listening all IP and accept all incoming IP. pg_hba.conf an postgresql.conf<br></div><div dir="ltr">Publishing succesfully multiple layers base on Postgis and everything seem to be ok.</div><div><br></div><div dir="ltr"><div dir="ltr">I try to make a template presenting ONE-TO-MANY content from PG to PG.(<a href="http://mapserver.org/mapfile/join.html" target="_blank">http://mapserver.org/mapfile/join.html</a>)</div></div><div dir="ltr">My ONE part is my geometry and is published in WMS</div><div dir="ltr">My MANY is an associated table. <br></div><div dir="ltr"><div>My key between my 2 tables is a unique string (21) named geocode</div><div>Both have PK. <br></div></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">Here my problem.</div><div dir="ltr"><br></div><div dir="ltr">On getfeatureinfo, it is suppose to return a html mime type for my template. Header, central (MANY) and FOOTER.</div><div dir="ltr">When I call the same dataset in DBF, the getfeatureinfo is returned properly.</div><div dir="ltr">When I call the same dataset in postgres, the getfeatureinfo is NOT returned properly.</div><div 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 dir="ltr"><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;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><br></span></div><div dir="ltr"><br></div><div dir="ltr">This example don't work properly. <br></div><div><br></div><div dir="ltr">TEMPLATE "oneToMany.html"<br>HEADER "oneToMany_header.html"<br>FOOTER "oneToMany_footer.html" <br></div><div dir="ltr"><br></div><div dir="ltr">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><br></div><div><br></div><div><br></div><div dir="ltr">This example work properly.<br></div><div><br></div><div dir="ltr">TEMPLATE "oneToMany.html"<br>HEADER "oneToMany_header.html"<br>FOOTER "oneToMany_footer.html" <br></div><div 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 dir="ltr"><div> END</div><div><br></div><div><br></div><div>Thanks!</div><div><br></div><span style="font-size:14pt;font-family:"Arial","sans-serif""></span></div><div>
<div><span style="font-size:12pt;font-family:"Arial","sans-serif"">Pierre-Étienne Lord</span></div><div><span style="font-size:12pt;font-family:"Arial","sans-serif""><br></span></div><span style="font-size:12pt;font-family:"Arial","sans-serif""><a href="https://outlook.mrnf.gouv.qc.ca/owa/redir.aspx?SURL=YaZ5UYf2IPMJv7ADsBDnNhbct83j8H_NQZOvg_R1SvvMdStAFEnTCG0AYQBpAGwAdABvADoAcABpAGUAcgByAGUALQBlAHQAaQBlAG4AbgBlAC4AbABvAHIAZABAAG0AZgBmAHAALgBnAG8AdQB2AC4AcQBjAC4AYwBhAA..&URL=mailto%3apierre-etienne.lord%40mffp.gouv.qc.ca" target="_blank"><span></span></a></span></div></div></div></div></div></div><br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></div>