Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

Good morning Michaël, Loïc, Add PostGIS Table(s) dialogue already shows our spatial enabled tables. We might just add another column to show if that geometry column is already indexed or not. We can add another action button to create it, enabled if missing. I've added a very simple mockup in

Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

Hi,And what about some snippets/useful query in DB manager like‎ pgModeler ? Regards.Loïc.

Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

Hi Jorge 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. 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

Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

I have improved my function. Now it returns a table containing the schema, table name and column name. You need to use it with SELECT * FROM create_missing_spatial_indexes(); If you would like to only get the informations about missing indexes, there is a new "simulate" parameter. SELECT * FROM

Re: [QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

Thank you very much! -- Sent from my mobile phone Il 01 Dic 2017 12:01 PM, "kimaidou" ha scritto: > Hi users and devs, > > I just created a very simple function [1] to create all the missing > spatial indexes on your table geometry columns. > > It is the 1st version, has no

[QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

Hi users and devs, I just created a very simple function [1] to create all the missing spatial indexes on your table geometry columns. It is the 1st version, has no fancy parameter to choose tables or schemas, nor return anything usefull (only notices). Use it with a simple SELECT