<html><head></head><body lang="fr-FR" style="background-color: rgb(255, 255, 255); line-height: initial;"> <div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">Hi,</div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br></div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">And what about some snippets/useful query in DB manager like pgModeler ? </div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br></div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">Regards.</div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br></div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">Loïc. </div> <div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br style="display:initial"></div> <div style="font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">Envoyé de mon smartphone BlackBerry 10.</div> <table width="100%" style="background-color:white;border-spacing:0px;"> <tbody><tr><td colspan="2" style="font-size: initial; text-align: initial; background-color: rgb(255, 255, 255);"> <div style="border-style: solid none none; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding: 3pt 0in 0in; font-family: Tahoma, 'BB Alpha Sans', 'Slate Pro'; font-size: 10pt;"> <div><b>De: </b>kimaidou</div><div><b>Envoyé: </b>dimanche 3 décembre 2017 09:37</div><div><b>À: </b>Jorge Gustavo Rocha</div><div><b>Cc: </b>qgis-developer</div><div><b>Objet: </b>Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes</div></div></td></tr></tbody></table><div style="border-style: solid none none; border-top-color: rgb(186, 188, 209); border-top-width: 1pt; font-size: initial; text-align: initial; background-color: rgb(255, 255, 255);"></div><br><div id="_originalContent" style=""><div dir="ltr"><div><div><div>Hi Jorge<br><br></div>This feature would be good to have in the DB manager, but I do not think we should create a function in any database without warning the user.<br><br></div>Inside QGIS, we should be less intrusive and only run the SELECT SQL inside the function to get all missing indexes, show them in a QGIS table view with checkboxes, and a button to create selected indexes.</div><div>I could propose a PR for this if I find time (heavy workload this end of year...)</div><div><br></div><div>Regards</div><div>Michaël<br></div><div><div><div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2017-12-01 17:09 GMT+01:00 Jorge Gustavo Rocha <span dir="ltr"><<a href="mailto:jgr@di.uminho.pt" target="_blank">jgr@di.uminho.pt</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Nice contribution, Michaël! Tested and approved :-)<br>
<br>
We might use this query to offer the option "Check missing spatial<br>
indexes" in DB Manager, with an additional checkbox to "Add missing<br>
indexes". Initially just for the Postgis provider, but it can be<br>
implemented for other providers.<br>
<br>
What do you think?<br>
<br>
Regards,<br>
<br>
Jorge Gustavo<br>
<span><br></span><br></blockquote></div><br></div></div></div></div></div></div></div>
<br><!--end of _originalContent --></div></body></html>