[Qgis-developer] Processing: Batch processing > Import into PostGIS | Error

Paolo Cavallini cavallini at faunalia.it
Mon Jul 7 13:00:52 PDT 2014


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all.
Apparently the
SRID is missing when attempting to batch import:

Algorithm Import into PostGIS starting...
Algorithm Import into PostGIS correctly executed...
Algorithm Import into PostGIS starting...
Error importing to PostGIS Errore nella creazione della sorgente dati
"public"."fvg_": ERROR: AddGeometryColumn() - invalid SRID CONTESTO:
SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)"
PL/pgSQL function addgeometrycolumn(character varying,character
varying,character varying,integer,character varying,integer,boolean)
line 5 at SQL statement

When importing one by one, everything OK.

BTW, it would be good to put sensible defaults for schema name (either
public or a dropdown) and table name (same as shp name, better if
converted with lowercase): should I open a ticket?

All the best, and thanks.
- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlO6/HMACgkQ/NedwLUzIr7OHACgh/i72liqXeLecM1DD4O9Ijkv
yqYAniCltOoDJIBph8L8ezzAcgvSLTos
=aZ8J
-----END PGP SIGNATURE-----


More information about the Qgis-developer mailing list