[QGIS-Developer] Creating a spatial index on a table created with QgsVectorLayerExporter Python function

[Jorge Gustavo Rocha]

Hi Andrea,

Às 17:17 de 14/03/21, Andrea Giudiceandrea escreveu:
> Jorge Gustavo Rocha wrote
>> I did the laziest test. I've tried to run 'Create spatial index' on a
>> Postgresql layer. Result was:
>>
>> Layer's data provider does not support spatial indexes [1]
> 
> Is PostGIS installed and enabled on the PostgreSQL db server?
> 

Yes, yes. I've ran the 'Create spatial index' on top of an existent
Postgis layer (with a role able to create spatial indexes). Have you
tried the same? Is it different on your side?

psql service=ftth -c "select postgis_full_version()"
POSTGIS="3.2.0dev 3.1.0rc1-47-gba2f659c0" [EXTENSION] PGSQL="120"
GEOS="3.8.0-CAPI-1.13.1 " PROJ="8.0.0" GDAL="GDAL
3.3.0dev-f6689b6533-dirty, released 2021/01/22" LIBXML="2.9.10"
LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" (core
procs from "3.1.0dev 3.1.0alpha2-36-g25825b61d" need upgrade) RASTER
(raster procs from "3.1.0dev 3.1.0alpha2-36-g25825b61d" need upgrade)

Regards,

Jorge

> Regards.
> 
> Andrea
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Gabinete 3.29 (Piso 3)
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor